drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Krystal (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-862) Select against hbase tables with empty number values fails
Date Thu, 29 May 2014 22:52:02 GMT
Krystal created DRILL-862:

             Summary: Select against hbase tables with empty number values fails 
                 Key: DRILL-862
                 URL: https://issues.apache.org/jira/browse/DRILL-862
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - HBase
            Reporter: Krystal


I have a hbase table that contains empty values for some columns/rows.   This was due to importing
data from a file into hbase. For example a get of a row containing empty age value in hbase:
hbase(main):003:0> get 'voterspaces', '17'
COLUMN                       CELL                                                        
 fourcf:create_date          timestamp=1401380832939, value=2014-06-04 06:49:06          
 onecf:name                  timestamp=1401380832939, value=alice garcia                 
 threecf:contributions       timestamp=1401380832939, value=468.51                       
 threecf:voterzone           timestamp=1401380832939, value=18555                        
 twocf:age                   timestamp=1401380832939, value=                             
 twocf:registration          timestamp=1401380832939, value=republican       

The following query from drill fails due to empty values instead of null:
select cast(row_key as integer) voter_id, convert_from(onecf['name'], 'UTF8') name, cast(twocf['age']
as integer) age, cast(twocf['registration'] as varchar(20)) registration, cast(threecf['contributions']
as decimal(6,2)) contributions, cast(threecf['voterzone'] as integer) voterzone,cast(fourcf['create_date']
as timestamp) create_date from voterspaces where row_key < 20;

message: "Failure while running fragment. < NumberFormatException:[  ]"

>From hive, running the same query against a hive table that is mapped to the same hbase
table succeeded.   If this how it expected to work in drill, then we should to document it.

This message was sent by Atlassian JIRA

View raw message