drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehant Baid (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1251) SQLException error when performing select against HBASE table
Date Mon, 04 Aug 2014 21:54:13 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1251?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14085373#comment-14085373
] 

Mehant Baid commented on DRILL-1251:
------------------------------------

The problem is that the CSV file includes a header indicating the column names which gets
inserted in HBase as is. After importing the csv into HBase when I execute the following command
on hbase shell
get 'products', 'prod_id'  I get back rows corresponding to this row_key.

In the query to Drill we are trying to cast row_key as an integer and it fails with NumberFormatException
on this particular row. Removing the header from csv file, importing into hbase again and
performing the query works fine. 

> SQLException error when performing select against HBASE table
> -------------------------------------------------------------
>
>                 Key: DRILL-1251
>                 URL: https://issues.apache.org/jira/browse/DRILL-1251
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Storage - HBase
>         Environment: 5-node mapR cluster, hbase 0.94.17 installed.
>            Reporter: Andy Pernsteiner
>         Attachments: hbase.sh, products.csv
>
>
> When attempting to query a 965 row HBASE table, I'm seeing an SQLException error after
843 lines are output.  CSV file and importtsv script are attached to this JIRA.  I've tried
removing any possible offending characters, to no avail.
> Here's the query:
> {code}
> select cast (row_key as int) as prod_id, cast
> (t.details.name as varchar(20)) as name, cast
> (t.details.category as varchar(20)) as category, cast
> (t.pricing.price as varchar(20)) as price
>  from
> hbase.`products` t;
> {code}
> And the output:
> {code}
> | 818        | Staples 6 Outlet Sur | Appliances | 12         |
> +------------+------------+------------+------------+
> |  prod_id   |    name    |  category  |   price    |
> +------------+------------+------------+------------+
> | 819        | Staples Battery-Oper | Pens & Art Supplies | 10         |
> | 82         | Avery 05222 Permanen | Labels     | 4          |
> | 820        | Staples Brown Kraft  | Envelopes  | 6          |
> | 821        | Staples Bulldog Clip | Rubber Bands | 4          |
> | 822        | Staples Colored Inte | Envelopes  | 31         |
> | 823        | Staples File Caddy | Storage & Organizati | 9          |
> | 824        | Staples� General Use | Binders and Binder A | 2          |
> | 825        | *Staples* Highlighti | Pens & Art Supplies | 5          |
> | 826        | *Staples* Letter Ope | ScissorsRulers and T | 2          |
> | 827        | Staples Metal Binder | Rubber Bands | 3          |
> | 828        | *Staples* Packaging  | Labels     | 3          |
> | 829        | Staples Pen Style Li | Pens & Art Supplies | 6          |
> | 83         | Avery� 3 1/2 Diskett | Binders and Binder A | 10         |
> | 830        | Staples Plastic Wall | Office Furnishings | 48         |
> | 831        | Staples Plastic Wall | Office Furnishings | 8          |
> | 832        | Staples Pushpins | Rubber Bands | 2          |
> | 833        | Staples SlimLine Pen | Pens & Art Supplies | 12         |
> | 834        | Staples Standard Env | Envelopes  | 6          |
> | 835        | Staples Surge Protec | Appliances | 11         |
> | 836        | *Staples* vLetter Op | ScissorsRulers and T | 4          |
> | 837        | Steel Personal Filin | Storage & Organizati | 36         |
> | 838        | Sterling Rubber Band | Rubber Bands | 5          |
> | 839        | Stockwell Push Pins | Rubber Bands | 2          |
> | 84         | Avery 4027 File Fold | Labels     | 31         |
> | 840        | Storex Dura Pro� Bin | Binders and Binder A | 6          |
> | 841        | Storex DuraTech Recy | Binders and Binder A | 4          |
> | 842        | Super Bands12/Pack | Rubber Bands | 2          |
> | 843        | Super Decoflex Porta | Storage & Organizati | 15         |
> java.lang.RuntimeException: java.sql.SQLException: Failure while trying to get next result
batch.
> 	at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> 	at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> 	at sqlline.SqlLine.print(SqlLine.java:1809)
> 	at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> 	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)
> {code}



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

Mime
View raw message