incubator-drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Varadharajan M <varad...@thoughtworks.com>
Subject Issues in connecting to remote drill from sqlline and executing queries
Date Thu, 17 Oct 2013 01:19:18 GMT
Hi All,

I've a drillbit instance running in my localhost which was started using
the zrillbit.sh script and it currently connects to the zookeeper also
running in my localhost at 2181. In the storage_engines.json file present
in conf directory, i've specified the following:

{
  "storage":{
    "parquet-local" :
      {
        "type":"parquet",
        "dfsName" : "file:///root/drill"
      },
    "parquet-cp" :
      {
        "type":"parquet",
        "dfsName" : "classpath:///"
      },
    "jsonl" :
      {
        "type":"json",
        "dfsName" : "file:///"
      },
    "json-cp" :
      {
        "type":"json",
        "dfsName" : "classpath:///"
      },
    "parquet" :
      {
        "type":"parquet",
        "dfsName" : "file:///"
      }
  }
}

where /root/drill is my DRILL_HOME directory and that is were sample-data
is present.

Now if i try to connect using sql and following JDBC string (!connect
jdbc:drill:@localhost:2181;schema=parquet-local), i could see that it
connects to the instance and when i try to execute one of the sample queies
(select * from "sample-data/region.parquet";) it gives me a table not found
exception

0: jdbc:drill:@localhost:2181> select * from "sample-data/region.parquet";
Oct 17, 2013 1:09:00 AM org.eigenbase.sql.validate.SqlValidatorException
<init>
SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table
'sample-data/region.parquet' not found
Oct 17, 2013 1:09:00 AM org.eigenbase.util.EigenbaseException <init>
SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column
15 to line 1, column 42
org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to
line 1, column 42
 at
org.eigenbase.resource.EigenbaseResource$_Def12.ex(EigenbaseResource.java:1026)
at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:739)
 at org.eigenbase.sql.SqlUtil.newContextException(SqlUtil.java:726)
at
org.eigenbase.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3830)
 at
org.eigenbase.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:78)
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:90)
 at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:802)
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:790)
 at
org.eigenbase.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2776)
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:3013)
 at
org.eigenbase.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:69)
at
org.eigenbase.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:90)
 at
org.eigenbase.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:802)
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:790)
 at org.eigenbase.sql.SqlSelect.validate(SqlSelect.java:154)
at
org.eigenbase.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:753)
 at
org.eigenbase.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:444)
at
org.eigenbase.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:445)
 at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:160)
at net.hydromatic.optiq.prepare.Prepare.prepareSql(Prepare.java:129)
 at
net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare2_(OptiqPrepareImpl.java:255)
at
net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepare_(OptiqPrepareImpl.java:195)
 at
net.hydromatic.optiq.prepare.OptiqPrepareImpl.prepareSql(OptiqPrepareImpl.java:168)
at
net.hydromatic.optiq.jdbc.OptiqStatement.parseQuery(OptiqStatement.java:402)
 at
net.hydromatic.optiq.jdbc.OptiqStatement.execute(OptiqStatement.java:192)
at sqlline.SqlLine$Commands.execute(SqlLine.java:3825)
 at sqlline.SqlLine$Commands.sql(SqlLine.java:3738)
at sqlline.SqlLine.dispatch(SqlLine.java:882)
at sqlline.SqlLine.begin(SqlLine.java:717)
 at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:460)
at sqlline.SqlLine.main(SqlLine.java:443)
Caused by: org.eigenbase.sql.validate.SqlValidatorException: Table
'sample-data/region.parquet' not found
at
org.eigenbase.resource.EigenbaseResource$_Def9.ex(EigenbaseResource.java:963)
 ... 27 more

Am i missing something here? I checked the logs and i could not see any
debug information as well.

- Varadha

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message