phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Krishna <research...@gmail.com>
Subject Re: Question regarding designing row keys
Date Tue, 04 Oct 2016 04:03:34 GMT
You have two options:
- Modify your primary key to include metric_type & timestamp as leading
columns.
- Create an index on metric_type & timestamp

On Monday, October 3, 2016, Kanagha <er.kanagha@gmail.com> wrote:

> Sorry for the confusion.
>
> metric_type,
> timestamp,
> metricId  is defined as the primary key via Phoenix for metric_table.
>
> Thanks
>
> Kanagha
>
> On Mon, Oct 3, 2016 at 3:41 PM, Michael McAllister <
> mmcallister@homeaway.com
> <javascript:_e(%7B%7D,'cvml','mmcallister@homeaway.com');>> wrote:
>
>> >
>>
>> there is no indexing available on this table yet.
>>
>> >
>>
>>
>>
>> So you haven’t defined a primary key constraint? Can you share your table
>> creation DDL?
>>
>>
>>
>> Michael McAllister
>>
>> Staff Data Warehouse Engineer | Decision Systems
>>
>> mmcallister@HomeAway.com
>> <javascript:_e(%7B%7D,'cvml','mmcallister@HomeAway.com');> | C:
>> 512.423.7447 | skype: michael.mcallister.ha
>> <javascript:_e(%7B%7D,'cvml','zimmkate@hotmail.com');> | webex:
>> https://h.a/mikewebex
>>
>> This electronic communication (including any attachment) is
>> confidential.  If you are not an intended recipient of this communication,
>> please be advised that any disclosure, dissemination, distribution, copying
>> or other use of this communication or any attachment is strictly
>> prohibited.  If you have received this communication in error, please
>> notify the sender immediately by reply e-mail and promptly destroy all
>> electronic and printed copies of this communication and any attachment.
>>
>>
>>
>> *From: *Kanagha <er.kanagha@gmail.com
>> <javascript:_e(%7B%7D,'cvml','er.kanagha@gmail.com');>>
>> *Reply-To: *"user@phoenix.apache.org
>> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>" <
>> user@phoenix.apache.org
>> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>>
>> *Date: *Monday, October 3, 2016 at 5:32 PM
>> *To: *"user@hbase.apache.org
>> <javascript:_e(%7B%7D,'cvml','user@hbase.apache.org');>" <
>> user@hbase.apache.org
>> <javascript:_e(%7B%7D,'cvml','user@hbase.apache.org');>>, "
>> user@phoenix.apache.org
>> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>" <
>> user@phoenix.apache.org
>> <javascript:_e(%7B%7D,'cvml','user@phoenix.apache.org');>>
>> *Subject: *Re: Question regarding designing row keys
>>
>>
>>
>> there is no indexing available on this table yet.
>>
>
>

Mime
View raw message