hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "stephen xie (JIRA)" <j...@apache.org>
Subject [jira] Commented: (HIVE-705) Let Hive can analyse hbase's tables
Date Thu, 13 Aug 2009 04:06:14 GMT

    [ https://issues.apache.org/jira/browse/HIVE-705?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12742704#action_12742704
] 

stephen xie commented on HIVE-705:
----------------------------------

Hi Samuel, 

  Also, I found the same problem as Kula.
  I changed one line in the method HiveInputFormat::getSplits,

---     newjob.set(TableInputFormat.COLUMN_LIST, hbaseColumns);
+++  job.set(TableInputFormat.COLUMN_LIST, hbaseColumns);

  Then the above java exception disappered, select is ok.

  But when I tested more than 2 columns, the query returned nothing.

CREATE TABLE hbase_table_2(key int, value1 string, value2 int) 
ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.hbase.HBaseSerDe' 
WITH SERDEPROPERTIES ("hbase.columns.mapping" = "cf:value1, cf:value2"
) STORED AS HBASETABLE;
FROM src2 INSERT OVERWRITE TABLE hbase_table_2 SELECT *;

The following 2 queries both returned nothing.
select * from hbase_table_2 where value > '0';
select * from hbase_table2;


> Let Hive can analyse hbase's tables
> -----------------------------------
>
>                 Key: HIVE-705
>                 URL: https://issues.apache.org/jira/browse/HIVE-705
>             Project: Hadoop Hive
>          Issue Type: New Feature
>            Reporter: Samuel Guo
>         Attachments: hbase-0.19.3-test.jar, hbase-0.19.3.jar, HIVE-705_draft.patch
>
>
> Add a serde over the hbase's tables, so that hive can analyse the data stored in hbase
easily.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message