drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-838) selecting from a directory created using CTAS from partitioned directory
Date Thu, 31 Jul 2014 05:53:40 GMT

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

Jacques Nadeau updated DRILL-838:
---------------------------------

    Fix Version/s:     (was: 0.4.0)
                   0.5.0

> 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
>            Assignee: Venki Korukanti
>             Fix For: 0.5.0
>
>
> 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)

Mime
View raw message