[ 
https://issues.apache.org/jira/browse/DRILL-4816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Dechang Gu updated DRILL-4816:
------------------------------
    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.

  was:
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.


> 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.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.



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

Reply via email to