[
https://issues.apache.org/jira/browse/DRILL-2284?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15837235#comment-15837235
]
Khurram Faraaz commented on DRILL-2284:
---------------------------------------
Can someone please look into this. A fix will make it easier to compare the
datatypes of a tables columns, when doing a comparison of same query execution
on different systems like Drill, Hive etc
Execute the same query on different SQL engines, and ensure we have the same
type of columns on both systems.
{noformat}
apache drill 1.10.0-SNAPSHOT
"a drill is a terrible thing to waste"
0: jdbc:drill:schema=dfs.tmp> describe typeall_l;
+--------------+------------+--------------+
| COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
+--------------+------------+--------------+
+--------------+------------+--------------+
No rows selected (0.629 seconds)
{noformat}
> Describe table returns no rows for Parquet / JSON / Text
> --------------------------------------------------------
>
> Key: DRILL-2284
> URL: https://issues.apache.org/jira/browse/DRILL-2284
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Reporter: Abhishek Girish
> Priority: Minor
> Fix For: Future
>
>
> 'Describe' table should either support displaying schema information or fail
> indicating the lack of support for Parquet / JSON / Text
> Currently no rows are returned, which might confuse an end user
> *Parquet/JSON/Text:*
> > describe store_sales;
> +--+
> | |
> +--+
> +--+
> No rows selected (0.07 seconds)
> *Hive:*
> > describe region;
> +-------------+------------+-------------+
> | COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
> +-------------+------------+-------------+
> | r_regionkey | INTEGER | YES |
> | r_name | VARCHAR | YES |
> | r_comment | VARCHAR | YES |
> +-------------+------------+-------------+
> *Views:*
> > describe ship_mode_par_view;
> +-------------+------------+-------------+
> | COLUMN_NAME | DATA_TYPE | IS_NULLABLE |
> +-------------+------------+-------------+
> | * | ANY | NO |
> +-------------+------------+-------------+
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
