[DRILL-541] hive-hbase tables query hangs

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Fix Version/s: 0.5.0
• Component/s: Storage - Hive
• Assignee: Venki Korukanti
• Reporter: Ramana Inukonda Nagaraj
• Created: 17/Apr/14 21:25
• Updated: 11/Feb/15 21:24
• Resolved: 05/Aug/14 21:30

Description

[root@perfnode166 drilltests]# hive -e "desc extended hbase_table_1";

Logging initialized using configuration in jar:file:/opt/mapr/hive/hive-0.12/lib/hive-common-0.12-mapr-1401-140130.jar!/hive-log4j.properties
OK
key int from deserializer
value string from deserializer

Detailed Table Information Table(tableName:hbase_table_1, dbName:default, owner:root, createTime:1397769348, lastAccessTime:0, retention:0, sd:StorageDescriptor(cols:[FieldSchema(name:key, type:int, comment:null), FieldSchema(name:value, type:string, comment:null)], location:maprfs:/user/hive/warehouse/hbase_table_1, inputFormat:org.apache.hadoop.hive.hbase.HiveHBaseTableInputFormat, outputFormat:org.apache.hadoop.hive.ql.io.HivePassThroughOutputFormat, compressed:false, numBuckets:-1, serdeInfo:SerDeInfo(name:null, serializationLib:org.apache.hadoop.hive.hbase.HBaseSerDe, parameters:

{serialization.format=1, hbase.columns.mapping=:key,cf1:val}

), bucketCols:[], sortCols:[], parameters:{}, skewedInfo:SkewedInfo(skewedColNames:[], skewedColValues:[], skewedColValueLocationMaps:{}), storedAsSubDirectories:false), partitionKeys:[], parameters:

{hbase.table.name=xyz, transient_lastDdlTime=1397769348, storage_handler=org.apache.hadoop.hive.hbase.HBaseStorageHandler}

, viewOriginalText:null, viewExpandedText:null, tableType:MANAGED_TABLE)
Time taken: 1.947 seconds, Fetched: 4 row(s)

Can be queried fine from hive.

From drill the query hangs. I have lilith setup but I am not sure what kind of information you need from there.

Issue Links

• is duplicated by: DRILL-1172 Unable to query Hive tables from Drill on CDH4