[DRILL-838] selecting from a directory created using CTAS from partitioned directory

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.5.0
• Component/s: Storage - Writer
• Assignee: Venki Korukanti
• Reporter: Ramana Inukonda Nagaraj
• Created: 27/May/14 00:32
• Updated: 06/Aug/14 23:50
• Resolved: 06/Aug/14 23:50

Description

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)