Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-4816

sqlline -f failed to read the query file

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.8.0
    • 1.8.0
    • Functions - Drill
    • None
    • redha 2.6.32-358.el6

    Description

      Installed Apache Drill master (commit id: 4e1bdac) on a 10 node cluster.

      sqlline -u "jdbc:drill:schema=dfs.xxxParquet" -f refresh_meta_dirs.sql

      hit the "No such file or directory" error:

      16:34:47,956 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy]
      16:34:47,956 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml]
      16:34:47,960 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [file:/mapr/drillPerf/
      drillbit/conf/logback.xml]
      16:34:47,961 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs multiple times on the cl
      asspath.
      16:34:47,961 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs at [file:/opt/mapr/drill
      /drill-1.8.0/conf/logback.xml]
      16:34:47,961 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs at [file:/mapr/drillPerf
      /drillbit/conf/logback.xml]
      16:34:48,163 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set
      16:34:48,168 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logbac
      k.core.rolling.RollingFileAppender]
      16:34:48,182 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [FILE]
      16:34:48,246 |-INFO in ch.qos.logback.core.rolling.FixedWindowRollingPolicy@29989e7c - No compression will be used
      16:34:48,246 |-WARN in ch.qos.logback.core.rolling.FixedWindowRollingPolicy@29989e7c - Large window sizes are not allowed.
      16:34:48,246 |-WARN in ch.qos.logback.core.rolling.FixedWindowRollingPolicy@29989e7c - MaxIndex reduced to 21
      16:34:48,257 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.class
      ic.encoder.PatternLayoutEncoder] for [encoder] property
      16:34:48,319 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - Active log file name: /var/log/drill/drillbit_
      ucs-node1.perf.lab.log
      16:34:48,319 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[FILE] - File property is set to [/var/log/drill/drillb
      it_ucs-node1.perf.lab.log]
      16:34:48,321 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting additivity of logger [org.apache.drill] to
      false
      16:34:48,321 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - org.apache.drill level set to INFO
      16:34:48,322 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [FILE] to Logger[org.apa
      che.drill]
      16:34:48,323 |-INFO in ch.qos.logback.classic.joran.action.LevelAction - ROOT level set to INFO
      16:34:48,323 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [FILE] to Logger[ROOT]
      16:34:48,323 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration.
      16:34:48,324 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@62ccf439 - Registering current configuration as safe fa
      llback point

      -u[i+1] (No such file or directory)
      Closing: org.apache.drill.jdbc.impl.DrillConnectionImpl

      running the query from inside the sqlline connection is ok.

      Attachments

        Issue Links

          Activity

            People

              parthc Parth Chandra
              dechanggu Dechang Gu
              Dechang Gu Dechang Gu
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: