You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org> on 2014/05/27 02:33:01 UTC
[jira] [Created] (DRILL-838) selecting from a directory created
using CTAS from partitioned directory
Ramana Inukonda Nagaraj created DRILL-838:
---------------------------------------------
Summary: 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)