[
https://issues.apache.org/jira/browse/HIVE-2373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13085478#comment-13085478
]
John Sichi commented on HIVE-2373:
----------------------------------
Posting the script somewhere and linking it from the wiki would be a good start:
https://cwiki.apache.org/confluence/display/Hive/HBaseIntegration
Putting something into Hive's HBase handler would be even better. There's no
need to add new reserved words; you could add new optional automapping
configuration parameters to the HBase handler.
> Importing hive tables into hbase+hive requires a lot of work which often can
> be implied
> ---------------------------------------------------------------------------------------
>
> Key: HIVE-2373
> URL: https://issues.apache.org/jira/browse/HIVE-2373
> Project: Hive
> Issue Type: Improvement
> Reporter: Alex Newman
> Priority: Minor
>
> The HiveQL way of creating a HBase table looks something like
> REATE TABLE bla(id_1 type_1, id_2 type_2..., id_n type_n)
> STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
> WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:id_2, cf:id_3")
> TBLPROPERTIES ("hbase.table.name" = "blah");
> But in most cases huge amounts of this can be assumed from the original table
> description. In fact in most cases, especially ones when that data was
> imported from MySQL it is trivial to generate at least one HBase backing for
> that data. I currently wrote a python script which our users can use to make
> things simpler. Would anyone be interested in that script? Would it make
> sense to make it easy from Hive? I hate to add reserved words so any
> suggestions are welcome.
--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira
