[
https://issues.apache.org/jira/browse/DRILL-3772?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Abhishek Girish updated DRILL-3772:
-----------------------------------
Summary: DROP TABLE fails for directories with files, having extensions not
defined part of DFS format plug-ins (was: DROP TABLE fails for directories
with PSV files)
> 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)
