drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andy Pernsteiner (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-1251) SQLException error when performing select against HBASE table
Date Sun, 03 Aug 2014 19:49:13 GMT

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

Andy Pernsteiner updated DRILL-1251:
------------------------------------

    Attachment: products.csv
                hbase.sh

Hbase.sh = > needs modification for your environment (paths/jars/etc) , will :

1) disable/drop the 'products' table if it exists
2) create a 'products' table w/ 2 CF's
3) launch importtsv against the CSV file, which is also attached.



> 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