Dechang Gu created DRILL-4816:
---------------------------------

             Summary: sqlline -f failed to read the query file
                 Key: DRILL-4816
                 URL: https://issues.apache.org/jira/browse/DRILL-4816
             Project: Apache Drill
          Issue Type: Bug
          Components: Functions - Drill
    Affects Versions: 1.8.0
         Environment: redha 2.6.32-358.el6
            Reporter: Dechang Gu
             Fix For: 1.8.0


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

sqlline -u "jdbc:drill:schema=dfs.comscoreParquet" -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.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to