drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aditya Kishore (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (DRILL-670) Queries selecting specific column names from hbase table hang
Date Wed, 21 May 2014 18:51:38 GMT

     [ https://issues.apache.org/jira/browse/DRILL-670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Aditya Kishore reassigned DRILL-670:
------------------------------------

    Assignee: Aditya Kishore

> Queries selecting specific column names from hbase table hang 
> --------------------------------------------------------------
>
>                 Key: DRILL-670
>                 URL: https://issues.apache.org/jira/browse/DRILL-670
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - HBase
>    Affects Versions: 1.0.0-milestone-1
>            Reporter: Krystal
>            Assignee: Aditya Kishore
>
> mapr-drill-1.0.0.25536-1.noarch
> I have an hbase table with the following properties:
> hbase(main):001:0> describe 'voter'
> DESCRIPTION                                                          ENABLED        
                     
>  'voter', {NAME => 'fourcf', DATA_BLOCK_ENCODING => 'NONE', BLOOMFIL true     
                           
>  TER => 'NONE', REPLICATION_SCOPE => '0', VERSIONS => '3', MIN_VERSI       
                              
>  ONS => '0', TTL => '2147483647', KEEP_DELETED_CELLS => 'false', BLO       
                              
>  CKSIZE => '65536', IN_MEMORY => 'false', ENCODE_ON_DISK => 'true',        
                              
>  BLOCKCACHE => 'true'}, {NAME => 'onecf', DATA_BLOCK_ENCODING => 'NO       
                              
>  NE', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0', VERSIONS => '       
                              
>  3', MIN_VERSIONS => '0', TTL => '2147483647', KEEP_DELETED_CELLS =>       
                              
>   'false', BLOCKSIZE => '65536', IN_MEMORY => 'false', ENCODE_ON_DIS          
                           
>  K => 'true', BLOCKCACHE => 'true'}, {NAME => 'threecf', DATA_BLOCK_       
                              
>  ENCODING => 'NONE', BLOOMFILTER => 'NONE', REPLICATION_SCOPE => '0'       
                              
>  , VERSIONS => '3', MIN_VERSIONS => '0', TTL => '2147483647', KEEP_D       
                              
>  ELETED_CELLS => 'false', BLOCKSIZE => '65536', IN_MEMORY => 'false'       
                              
>  , ENCODE_ON_DISK => 'true', BLOCKCACHE => 'true'}, {NAME => 'twocf'       
                              
>  , DATA_BLOCK_ENCODING => 'NONE', BLOOMFILTER => 'NONE', REPLICATION          
                           
>  _SCOPE => '0', VERSIONS => '3', MIN_VERSIONS => '0', TTL => '214748    
                                 
>  3647', KEEP_DELETED_CELLS => 'false', BLOCKSIZE => '65536', IN_MEMO          
                           
>  RY => 'false', ENCODE_ON_DISK => 'true', BLOCKCACHE => 'true'}            
                              
> Ran the following query from sqlline:
> select name, age from voter limit 5;
> The query hangs.  Here is part of the java stack trace for the sqlline process:
> "Finalizer" daemon prio=10 tid=0x00007f3ec4073000 nid=0x25c4 in Object.wait() [0x00007f3ec8d79000]
>    java.lang.Thread.State: WAITING (on object monitor)
> 	at java.lang.Object.wait(Native Method)
> 	- waiting on <0x00000000c4190f98> (a java.lang.ref.ReferenceQueue$Lock)
> 	at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:135)
> 	- locked <0x00000000c4190f98> (a java.lang.ref.ReferenceQueue$Lock)
> 	at java.lang.ref.ReferenceQueue.remove(ReferenceQueue.java:151)
> 	at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:189)
> "Reference Handler" daemon prio=10 tid=0x00007f3ec406f000 nid=0x25c3 in Object.wait()
[0x00007f3ec8e7a000]
>    java.lang.Thread.State: WAITING (on object monitor)
> 	at java.lang.Object.wait(Native Method)
> 	- waiting on <0x00000000c4190b10> (a java.lang.ref.Reference$Lock)
> 	at java.lang.Object.wait(Object.java:503)
> 	at java.lang.ref.Reference$ReferenceHandler.run(Reference.java:133)
> 	- locked <0x00000000c4190b10> (a java.lang.ref.Reference$Lock)
> "main" prio=10 tid=0x00007f3ec4011800 nid=0x25bf waiting on condition [0x00007f3ecada7000]
>    java.lang.Thread.State: WAITING (parking)
> 	at sun.misc.Unsafe.park(Native Method)
> 	- parking to wait for  <0x00000000ecd4dd18> (a java.util.concurrent.CountDownLatch$Sync)
> 	at java.util.concurrent.locks.LockSupport.park(LockSupport.java:186)
> 	at java.util.concurrent.locks.AbstractQueuedSynchronizer.parkAndCheckInterrupt(AbstractQueuedSynchronizer.java:834)
> 	at java.util.concurrent.locks.AbstractQueuedSynchronizer.doAcquireSharedInterruptibly(AbstractQueuedSynchronizer.java:994)
> 	at java.util.concurrent.locks.AbstractQueuedSynchronizer.acquireSharedInterruptibly(AbstractQueuedSynchronizer.java:1303)
> 	at java.util.concurrent.CountDownLatch.await(CountDownLatch.java:236)
> 	at org.apache.drill.jdbc.DrillResultSet.execute(DrillResultSet.java:88)
> 	at org.apache.drill.jdbc.DrillResultSet.execute(DrillResultSet.java:43)
> 	at net.hydromatic.avatica.AvaticaConnection.executeQueryInternal(AvaticaConnection.java:404)
> 	at net.hydromatic.avatica.AvaticaStatement.executeQueryInternal(AvaticaStatement.java:350)
> 	at net.hydromatic.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:337)
> 	at net.hydromatic.avatica.AvaticaStatement.execute(AvaticaStatement.java:69)
> 	at sqlline.SqlLine$Commands.execute(SqlLine.java:3755)
> 	at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> 	at sqlline.SqlLine.dispatch(SqlLine.java:889)
> 	at sqlline.SqlLine.begin(SqlLine.java:763)
> 	at sqlline.SqlLine.start(SqlLine.java:498)
> 	at sqlline.SqlLine.main(SqlLine.java:460)
> Selecting all column (*) returns data.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message