[
https://issues.apache.org/jira/browse/HIVE-2373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13085498#comment-13085498
]
Alex Newman commented on HIVE-2373:
-----------------------------------
@John, I'm doing some internal review before I paste it. I'm guessing I'm
looking at some guidance of what it should look like from someone else, if they
have thought of it. I guess I could just add an auto for the configuration
parameter.
> 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