Member since
07-02-2016
23
Posts
6
Kudos Received
1
Solution
My Accepted Solutions
Title | Views | Posted |
---|---|---|
5096 | 08-12-2016 01:11 PM |
08-17-2016
04:32 AM
Thanks for the reply. We are using HDP2.3 and Phoenix 4.4. Hence I'm planning to use pig integration mentioned below for Hive to Phoenix table transfer.
... View more
08-12-2016
01:11 PM
I'm planning to use approach mentioned below using phoenix-pig integration. https://community.hortonworks.com/questions/12538/phoenix-storage-in-pig.html
... View more
08-11-2016
01:01 PM
@Josh Elser Can I use PhoenixStorageHandler while creating Hive table? Mentioned here: https://github.com/nmaillard/Phoenix-Hive
... View more
08-09-2016
10:44 AM
Thanks for the reply @Ankit Singhal I am populating Hbase table through Hive table. CREATE TABLE sdm_report__301__301_hive (order_by bigint, virus_id bigint, virus_name string, server_date date)
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ('hbase.columns.mapping' = ':key, family:vid, family:name, family:server_date')
TBLPROPERTIES ('hbase.table.name' = 'sdm_report__301__301_hbase');
INSERT OVERWRITE TABLE sdm_report__301__301_hive SELECT * FROM sdm_report__301__301;
How should I use API you mentioned while inserting data into Hbase table through Hive? Is there a way to map 'PInteger' class datatype while creating Hbase table? Or is there a way to directly create Phoenix table through Hive?
... View more
08-08-2016
04:19 PM
Thank for the reply Josh. My use-case is: Data is going to get populated into Hbase table. I'm going to create a Phoenix table on top of Hbase table so that I can fire SQL on it. So I'm going to just read data from Phoenix table.
... View more
08-08-2016
04:11 PM
1 Kudo
I have Hbase table with integer field. When I map Phoenix table on to this Hbase table, integer field show values like : -213456236 E.g. hbase> create 'emp','f1'
hbase> put 'emp',1,'f1:eid',1001
Corresponding Phoenix table: Create table "emp" (pk integer primary key, "f1"."eid" integer); When I try to select from emp table, I get large number in eid field: select "eid" from "emp";
=> 299345678 This is happening for float values also. Whereas varchar values get populated correctly. What wrong am I doing? Am I wrongly mapping the Hbase table to phoenix? I have followed steps from FAQ page. I have read below question, but unable to get any clue. https://community.hortonworks.com/questions/15381/created-phoenix-view-to-map-existing-hbase-table-b.html Please help @Josh Elser
... View more
Labels:
- Labels:
-
Apache HBase
-
Apache Phoenix