[DRILL-4816] sqlline -f failed to read the query file

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

Environment

redha 2.6.32-358.el6

• Assignee: Parth Chandra
• Reporter: Dechang Gu
• Reviewer: Dechang Gu
• Created: 29/Jul/16 23:45
• Updated: 22/Aug/16 22:06
• Resolved: 03/Aug/16 18:39

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.

Issue Links

• links to: GitHub Pull Request #557