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
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