You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jinfeng Ni (JIRA)" <ji...@apache.org> on 2015/06/29 20:54:05 UTC
[jira] [Commented] (DRILL-3400) After shifting CTAS's data, query
on CTAS table failed
[ https://issues.apache.org/jira/browse/DRILL-3400?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14606133#comment-14606133 ]
Jinfeng Ni commented on DRILL-3400:
-----------------------------------
Could you please list the detailed steps to re-produce this problem?
Everything seems to work to be fine on my machine.
{code}
+-------+--------------------------------------+
| ok | summary |
+-------+--------------------------------------+
| true | Default schema changed to [dfs.tmp] |
+-------+--------------------------------------+
1 row selected (1.233 seconds)
0: jdbc:drill:zk=local> create table `ttt` partition by (r_regionkey) as select * from cp.`tpch/region.parquet`;
+-----------+----------------------------+
| Fragment | Number of records written |
+-----------+----------------------------+
| 0_0 | 5 |
+-----------+----------------------------+
1 row selected (2.081 seconds)
0: jdbc:drill:zk=local> select * from dfs.`/tmp/Q1/0_0_1.parquet`;
+--------------+---------+----------------------------------------------------------------------------------------------------------------------+
| r_regionkey | r_name | r_comment |
+--------------+---------+----------------------------------------------------------------------------------------------------------------------+
| 0 | AFRICA | lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to |
+--------------+---------+----------------------------------------------------------------------------------------------------------------------+
1 row selected (0.15 seconds)
0: jdbc:drill:zk=local> select * from `ttt`;
+--------------+--------------+----------------------------------------------------------------------------------------------------------------------+
| r_regionkey | r_name | r_comment |
+--------------+--------------+----------------------------------------------------------------------------------------------------------------------+
| 0 | AFRICA | lar deposits. blithely final packages cajole. regular waters are final requests. regular accounts are according to |
| 1 | AMERICA | hs use ironic, even requests. s |
| 2 | ASIA | ges. thinly even pinto beans ca |
| 3 | EUROPE | ly final courts cajole furiously final excuse |
| 4 | MIDDLE EAST | uickly special accounts cajole carefully blithely close requests. carefully final asymptotes haggle furiousl |
+--------------+--------------+----------------------------------------------------------------------------------------------------------------------+
5 rows selected (0.19 seconds)
{code}
> After shifting CTAS's data, query on CTAS table failed
> -------------------------------------------------------
>
> Key: DRILL-3400
> URL: https://issues.apache.org/jira/browse/DRILL-3400
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Sean Hsuan-Yi Chu
> Assignee: Jinfeng Ni
>
> A simple query like this:
> create table `ttt` partition by (r_regionkey) as select * from cp.`tpch/region.parquet`;
> Without touching generated data from CTAS, this query select * from `ttt`; works.
> Then, I tried to reorganize the parquet generated by CTAS as:
> |-----Q1/ ... .pq
> Q2/ ... .pq
> Q3/ ... .pq
> However, after this manual moving, any query fails. Surprisingly, even after I manually move the data to the original place, the queries which worked before all failed with:
> Error: PARSE ERROR: From line 1, column 15 to line 1, column 19: Table 'ttt' not found
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)