You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Dechang Gu (JIRA)" <ji...@apache.org> on 2016/07/29 23:51:20 UTC
[jira] [Updated] (DRILL-4816) sqlline -f failed to read the query
file
[ 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)