drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jinfeng Ni (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3400) After shifting CTAS's data, query on CTAS table failed
Date Mon, 29 Jun 2015 18:54:05 GMT

    [ 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)

Mime
View raw message