org.apache.calcite.runtime.CalciteContextException: From > line > >>>> 1, column 15 to line 1, column 30: Table > >>>> 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' > not > >>>> found > >>>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > >>>> Method) ~[na:1.8.0_45] > >>>>> at > >>>> > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > >>>> ~[na:1.8.0_45] > >>>>> at > >>>> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > >>>> ~[na:1.8.0_45] > >>>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:422) > >>>> ~[na:1.8.0_45] > >>>>> at > >>>> > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:689) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:674) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3750) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:106) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2745) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2730) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2953) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210)

drill-user | Amit Hadke | 1 year ago
  1. 0

    Re: help with ApacheDrill and S3

    drill-user | 1 year ago | Amit Hadke
    org.apache.calcite.runtime.CalciteContextException: From > line > >>>> 1, column 15 to line 1, column 30: Table > >>>> 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' > not > >>>> found > >>>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > >>>> Method) ~[na:1.8.0_45] > >>>>> at > >>>> > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > >>>> ~[na:1.8.0_45] > >>>>> at > >>>> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > >>>> ~[na:1.8.0_45] > >>>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:422) > >>>> ~[na:1.8.0_45] > >>>>> at > >>>> > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:689) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:674) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3750) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:106) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2745) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2730) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2953) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210)

    Root Cause Analysis

    1. org.apache.calcite.runtime.CalciteContextException

      From > line > >>>> 1, column 15 to line 1, column 30: Table > >>>> 's3sccapachedrill.root.oletv_server_event.log.2014-12-16-10-55.csv' > not > >>>> found > >>>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native > >>>> Method) ~[na:1.8.0_45] > >>>>> at > >>>> > sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) > >>>> ~[na:1.8.0_45] > >>>>> at > >>>> > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) > >>>> ~[na:1.8.0_45] > >>>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:422) > >>>> ~[na:1.8.0_45] > >>>>> at > >>>> > org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:348) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:689) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:674) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:3750) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:106) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2745) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:2730) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:2953) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:60) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:86) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:874) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at > >>>> > org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:863) > >>>> ~[calcite-core-1.1.0-drill-r14.jar:1.1.0-drill-r14] > >>>>> at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:210)

      at java.lang.reflect.Constructor.newInstance()
    2. Java RT
      Constructor.newInstance
      1. java.lang.reflect.Constructor.newInstance(Constructor.java:422)
      1 frame