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

sqlline -f failed to read the query file

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.8.0
    • Fix Version/s: 1.8.0
    • Component/s: Functions - Drill
    • Labels:
      None
    • Environment:

      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

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

                Dates

                • Created:
                  Updated:
                  Resolved: