Member since
07-30-2017
3
Posts
0
Kudos Received
0
Solutions
08-04-2017
11:06 AM
Thanks, but actually, I want to do scanning in hbase coprocessor for which I require the row-key. The scan should be for a specific feature and time stamp to do some aggregations. So I need to use scan.setStartRow() and scan.setStoprow() with appropriate row-keys formed by feature and TS.
... View more
08-04-2017
09:37 AM
I created a table through phoenix as: CREATE TABLE MyTab ( Feature varchar(10),
ts DATE NOT NULL, val INTEGER, avg varchar(10)
CONSTRAINT pk PRIMARY KEY (tag, ts) )COLUMN_ENCODED_BYTES=0; Inserted 100 row to it. The Hbase scan for MyTab shows this( Just copied only 1 row-key data): Temp\x00\x80\x00\x01]\x9Fh@\xE2 column=0:VAL, timestamp=1501598196006, value=\x80\x00\x00\x16
Temp\x00\x80\x00\x01]\x9Fh@\xE2 column=0:_0, timestamp=1501598196006, value=x this means Temp\x00\x80\x00\x01]\x9Fh@\xE2 is the row- key, So, when I do a get like : get 'MyTab', 'Temp\x00\x80\x00\x01]\x9Fh@\xE2', '0:VAL' I get no results. How would I get the value of column VAL TS value inserted to Phoenix is 2017-08-01 20:06:35.998 and Feature is Temp.
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix
07-30-2017
11:27 AM
I have a created a phoenix table test with the following schema CREATE TABLE test ( tag varchar(10) NOT NULL,
ts DATE NOT NULL,
val INTEGER
CONSTRAINT pk PRIMARY KEY (tag, ts)
) Now I want to know how these "tag", "ts", "val" fields are stored in HBase and with what name. Would it be something like "columnFamily:qualifier" i.e "0:tag". I am using apache-phoenix-4.11.0-HBase-1.3-bin.
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix