Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Drill, mail # dev - Re: [jira] [Commented] (DRILL-159) 1.sql


Copy link to this message
-
Re: [jira] [Commented] (DRILL-159) 1.sql
Sree V 2013-07-30, 23:33
Hi Julian,

Capitalized dataset
{"ORDERKEY":"1","PARTKEY":"155190","SUPPLIERKEY":"7706","LINENUMBER":"1","QUANTITY":"17","EXTENDEDPRICE":"21168.23","DISCOUNT":"0.04","TAX":"0.02","RETURNFLAG":"N","LINESTATUS":"O","SHIPPINGDATE":"1996-03-13","COMMITTEDDATE":"1996-02-12","RECEIVEDDATE":"1996-03-22","SHIPPINGINSTRUCTIONS":"DELIVER IN PERSON","SHIPPINGMODE":"TRUCK","COMMENT":"egular courts above the"}

Capitalized query

ResultSet resultSet = statement.executeQuery("SELECT QUANTITY FROM LINEITEM");
Still the same issue.

Jul 30, 2013 4:30:23 PM org.eigenbase.sql.validate.SqlValidatorException <init>
SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Column 'QUANTITY' not found in any table
Jul 30, 2013 4:30:23 PM org.eigenbase.util.EigenbaseException <init>
SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column 8 to line 1, column 15

I notice the whole query is CAPITALIZED in the work flow after it is read.

Thanks,

V

________________________________
 From: Julian Hyde <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]; Sree V <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2013 2:21 PM
Subject: Re: [jira] [Commented] (DRILL-159) 1.sql
 

The problem might be case-sensitivity. When you execute '!columns', is the column defined as RETURNFLAG or returnFlag?

In the query, identifiers are not enclosed in double-quotes, so they are automatically converted to upper case. If the column is called returnFlag then the RETURNFLAG asked for by the query will not match.

Julian