Member since
03-29-2016
2
Posts
5
Kudos Received
0
Solutions
03-30-2016
03:13 AM
Hi Maillard, Thank you for your reply basically i am trying to convert a phoenix query to hbase query Phoenix query: SELECT PRODUCT_KEY,
STORE_KEY, PERIOD_KEY , U_PER_STORE_WEEKS_PROJ FROM FG.FCT FCT where PRODUCT_KEY in ( SELECT
PRODUCT_KEY FROM FG.PRDC ) AND STORE_KEY in ( SELECT
STORE_KEY FROM FG.STR WHERE STORE IN ( '03441' ) ) AND PERIOD_KEY in ( SELECT
PERIOD_KEY FROM FG.PRD WHERE PERIOD_SHORT_DESC IN ('Super Bowl 2 W/E
02/07/15') ); Can this be done and can you let me know on how to start with for the conversion
... View more
03-29-2016
08:44 AM
5 Kudos
Phoenix Query: CREATE TABLE STORE.DETAILS (Market_Key UNSIGNED_INT NOT NULL, Product_Key UNSIGNED_INT NOT NULL, Period_Key UNSIGNED_INT NOT NULL, Units double CONSTRAINT pk PRIMARY KEY (Market_Key, Product_Key, Period_Key)) In hbase i am having two columns i hope Primary key combination is converted to row key. can you please let me know how the primary keys are combined and converted to rowkeys
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix