Andy Pernsteiner created DRILL-1251:
---------------------------------------
Summary: 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
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)
