oing to that
>> direction. It's much straightforward to make time stamp part of primary
>> key, so the two dimension structure could be represented by multiple rows
>> naturally in SQL result.
>>
>> Randy
>>
>>
>>
>>
>> --
>> View
ess and awkwardness it could be if going to that
> direction. It's much straightforward to make time stamp part of primary
> key, so the two dimension structure could be represented by multiple rows
> naturally in SQL result.
>
> Randy
>
>
>
>
> --
> View this mess
this message in context:
http://apache-phoenix-user-list.1124778.n5.nabble.com/phoenix-query-modtime-tp3702p3716.html
Sent from the Apache Phoenix User List mailing list archive at Nabble.com.
thanks, useful stuff. I am a bit confuse, from the document
"Only a primary key column of type TIME, DATE, TIMESTAMP, BIGINT,
UNSIGNED_LONG can be designated as ROW_TIMESTAMP"
why this modtime mapping column has to be part of the primary key? it's a
lot more flexible if such a constraint not exi
Ah, you are trying to use the row_timestamp feature, not sure if there is a
way from SQL if that column is not in pk.
but if you are open to using an unexposed API, here is some snippet (please
use them at your discretion as these APIs are internal and have no
guarantee to be consistent in version
sorry, maybe I did not make it clear, I have a hbase table, already
formatted with phoenix format and has composite key, I can query all the
columns I want, but I can not query the hbase modtime in phoenix query, any
way to do this?
Nan
On Fri, Jun 23, 2017 at 1:23 AM, Ankit Singhal
wrote:
> If
If you have composite columns in your row key of HBase table and they are
not formed through Phoenix then you can't access an individual column of
primary key by Phoenix SQL too.
Try composing the whole PK and use them in a filter or may check if you can
use regex functions[1] or LIKE operator.
[1
I have a phoenix table created on existing hbase table, and want to query
something like
select * from mytable where modtime>'2010-01-01',
how do I query phoenix like this? seems it doesn't have a modtime column if
I don't do the modtime mapping, which I can not do because it has to be
part of the
