[
https://issues.apache.org/jira/browse/DRILL-838?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14009175#comment-14009175
]
Ramana Inukonda Nagaraj commented on DRILL-838:
-----------------------------------------------
git.commit.id.abbrev=5b8f8d8
> selecting from a directory created using CTAS from partitioned directory
> ------------------------------------------------------------------------
>
> Key: DRILL-838
> URL: https://issues.apache.org/jira/browse/DRILL-838
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Writer
> Reporter: Ramana Inukonda Nagaraj
>
> Steps to repro:
> [root@drillats1 framework]# hadoop fs -ls
> /drill/testdata/text_storage/lineitempart
> Found 7 items
> drwxr-xr-x - root root 1 2014-05-17 00:49
> /drill/testdata/text_storage/lineitempart/1991
> drwxr-xr-x - root root 1 2014-05-17 00:49
> /drill/testdata/text_storage/lineitempart/1992
> drwxr-xr-x - root root 1 2014-05-17 00:49
> /drill/testdata/text_storage/lineitempart/1993
> drwxr-xr-x - root root 1 2014-05-17 00:49
> /drill/testdata/text_storage/lineitempart/1994
> drwxr-xr-x - root root 1 2014-05-17 00:49
> /drill/testdata/text_storage/lineitempart/1995
> drwxr-xr-x - root root 1 2014-05-17 00:49
> /drill/testdata/text_storage/lineitempart/1996
> drwxr-xr-x - root root 1 2014-05-17 00:49
> /drill/testdata/text_storage/lineitempart/1997
> CREATE TABLE CTAS_SELECTPART AS select columns[0],
> columns[1],
> columns[4],
> columns[10],
> columns[13]
> from `/drill/testdata/text_storage/lineitempart` where dir0=1993;
> Table is created succesfully.
> [root@drillats1 framework]# hadoop fs -ls /drill/testdata/CTAS*
> -rwxr-xr-x 3 root root 0 2014-05-27 00:16
> /drill/testdata/CTAS_SELECTPART/1_0_0.parquet
> -rwxr-xr-x 3 root root 137104 2014-05-27 00:16
> /drill/testdata/CTAS_SELECTPART/1_1_0.parquet
> -rwxr-xr-x 3 root root 0 2014-05-27 00:16
> /drill/testdata/CTAS_SELECTPART/1_2_0.parquet
> -rwxr-xr-x 3 root root 0 2014-05-27 00:16
> /drill/testdata/CTAS_SELECTPART/1_3_0.parquet
> -rwxr-xr-x 3 root root 0 2014-05-27 00:16
> /drill/testdata/CTAS_SELECTPART/1_4_0.parquet
> -rwxr-xr-x 3 root root 0 2014-05-27 00:16
> /drill/testdata/CTAS_SELECTPART/1_5_0.parquet
> -rwxr-xr-x 3 root root 0 2014-05-27 00:16
> /drill/testdata/CTAS_SELECTPART/1_6_0.parquet
> A select * from results in an error
> 0: jdbc:drill:schema=dfs.drillTestDir> select * from CTAS_SELECTPART;
> Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while
> running query.[error_id: "916bb5cb-204d-4845-8538-7379c42d7326"
> endpoint {
> address: "drillats3.qa.lab"
> user_port: 31010
> control_port: 31011
> data_port: 31012
> }
> error_type: 0
> message: "Failure while setting up Foreman. < AssertionError:[ Internal
> error: Error while applying rule DrillTableRule, args
> [rel#7521:EnumerableTableAccessRel.ENUMERABLE.ANY([]).[](table=[dfs,
> drillTestDir, CTAS_SELECTPART])] ] < AssertionError:[ Internal error: Error
> occurred while applying rule DrillTableRule ] < UndeclaredThrowableException
> < InvocationTargetException < NullPointerException"
> ]
> Error: exception while executing query (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.2#6252)
