Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-541

hive-hbase tables query hangs

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Resolved
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 0.5.0
    • Component/s: Storage - Hive
    • Labels:
      None

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                vkorukanti Venki Korukanti
                Reporter:
                inramana Ramana Inukonda Nagaraj
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: