Krystal created DRILL-670:
-----------------------------
Summary: 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
Affects Versions: 1.0.0-milestone-1
Reporter: Krystal
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)
