[
https://issues.apache.org/jira/browse/DRILL-3810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15053589#comment-15053589
]
Chun Chang commented on DRILL-3810:
-----------------------------------
For avrò file, we do fail fast.
{noformat}
0: jdbc:drill:schema=dfs.drillTestDir> select username, tweet from
dfs.`/drill/testdata/avro/twitter.avro`;
+-------------+--------------------------------------+
| username | tweet |
+-------------+--------------------------------------+
| miguno | Rock: Nerf paper, scissors is fine. |
| BlizzardCS | Works as intended. Terran is IMBA. |
+-------------+--------------------------------------+
2 rows selected (0.261 seconds)
0: jdbc:drill:schema=dfs.drillTestDir> select username, lost_tweet from
dfs.`/drill/testdata/avro/twitter.avro`;
Error: VALIDATION ERROR: From line 1, column 18 to line 1, column 27: Column
'lost_tweet' not found in any table
[Error Id: 167127e6-4fc1-4959-a269-747b0a3146a9 on 10.10.30.168:31010]
(state=,code=0)
{noformat}
> Filesystem plugin's support for file format's schema
> ----------------------------------------------------
>
> Key: DRILL-3810
> URL: https://issues.apache.org/jira/browse/DRILL-3810
> Project: Apache Drill
> Issue Type: Improvement
> Components: Storage - JSON, Storage - Other, Storage - Parquet,
> Storage - Text & CSV
> Reporter: Bhallamudi Venkata Siva Kamesh
> Assignee: Bhallamudi Venkata Siva Kamesh
> Fix For: 1.3.0
>
>
> Filesystem Plugin supports multiple type of file formats like
> * json
> * avro
> * text (csv|psv|tsv)
> * parquet
> and can support any type of file formats.
> Among these file formats, some of the file formats are schema based like
> *avro* and *parquet* and some of them are schema less like *json*.
> For schema based file formats, Drill should have capability to validate the
> query against file schema, before start executing the query.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
