drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3772) DROP TABLE fails for directories with files, having extensions not defined part of DFS format plug-ins
Date Mon, 14 Sep 2015 17:32:45 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3772?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14743878#comment-14743878
] 

Rahul Challapalli commented on DRILL-3772:
------------------------------------------

+1 Abhishek

We should be able to drop tables with common extensions such as txt, dat etc which are not
defined in the format plugin unless there is a good reason not to



> DROP TABLE fails for directories with files, having extensions not defined part of DFS
format plug-ins
> ------------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-3772
>                 URL: https://issues.apache.org/jira/browse/DRILL-3772
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.2.0
>            Reporter: Abhishek Girish
>            Assignee: Jinfeng Ni
>         Attachments: drillbit.log.txt
>
>
> I created a simple PSV file with one row. Copied it twice into a directory. Put it on
hadoop. Drop table failed, complaining that the directory contains non homogeneous files.

> {code}
> # cp a.psv b.psv
> # cp a.psv b.psv t1
> # hadoop fs -put t1 /tmp/t2
> 0: jdbc:drill:schema=dfs> select * from dfs.tmp.t2;
> +--------------+
> |   columns    |
> +--------------+
> | ["2|3|4|5"]  |
> | ["2|3|4|5"]  |
> +--------------+
> 2 rows selected (1.338 seconds)
> 0: jdbc:drill:schema=dfs> drop table dfs.tmp.t2;
> Error: VALIDATION ERROR: Table contains different file formats.
> Drop Table is only supported for directories that contain homogeneous file formats consumable
by Drill
> [Error Id: 19763856-1a23-4438-a7f1-18f6dc280b0b on atsqa6c86.qa.lab:31010] (state=,code=0)
> {code}
> Works with CSV files:
> {code}
> # mv a.psv a.csv
> # mv b.psv b.csv
> # hadoop fs -put t1 /tmp/t3
> [root@atsqa6c85 ~]# /opt/drill/bin/sqlline -u jdbc:drill:schema=dfs;zk=10.10.104.85:5181
> apache drill 1.0.0
> "got drill?"
> 0: jdbc:drill:schema=dfs> use dfs.tmp;
> +-------+--------------------------------------+
> |  ok   |               summary                |
> +-------+--------------------------------------+
> | true  | Default schema changed to [dfs.tmp]  |
> +-------+--------------------------------------+
> 1 row selected (2.211 seconds)
> 0: jdbc:drill:schema=dfs> drop table t3;
> +-------+---------------------+
> |  ok   |       summary       |
> +-------+---------------------+
> | true  | Table [t3] dropped  |
> +-------+---------------------+
> 1 row selected (0.56 seconds)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message