Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
One difference is the error message:
not found in any table Vs not found in table 'TABLENAME'.

ResultSet resultSet = statement.executeQuery("select QUANTITY from lineitem");

Jul 30, 2013 4:35:07 PM org.eigenbase.sql.validate.SqlValidatorException <init>
SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Column 'QUANTITY' not found in table 'LINEITEM'
Jul 30, 2013 4:35:07 PM org.eigenbase.util.EigenbaseException <init>
SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column 17 to line 1, column 24

V
________________________________
 From: Sree V <[EMAIL PROTECTED]>
To: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
Sent: Tuesday, July 30, 2013 4:33 PM
Subject: Re: [jira] [Commented] (DRILL-159) 1.sql
 

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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB