[
https://issues.apache.org/jira/browse/HIVE-25660?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Simon AUBERT updated HIVE-25660:
--------------------------------
Description:
Hello all,
As of today, when you want to know the file format of every table, you have, as
far I know, two solutions :
-a loop in shell
-a loop in the tool you use for HQL queries, and then parse the answer, etc..
I think this is way too complicated for such a very basic need. So a
table_file_format (or partition_file_format, I don't know) in the
information_schema would be a very precious help for monitoring. It can be
directly read by a reporting tool (Superset, Tableau, PowerBi, Qlik, whatever
you want).
Best regards,
Simon
was:
Hello all,
As of today, when you want to know the file format of every table, you have, as
far I know, two solutions :
-a loop in shell
-a loop in the tool you use for HQL queries, and then parse the answer, etc..
I think this is way too complicated for such a very basic need. So a
table_file_format (or partition_file_format, I don't know) in the
information_schema would be a very precious help for monitoring.
Best regards,
Simon
> File Format (ORC/AVRO/TextFile...) available in information schema for bulk
> query
> ---------------------------------------------------------------------------------
>
> Key: HIVE-25660
> URL: https://issues.apache.org/jira/browse/HIVE-25660
> Project: Hive
> Issue Type: Improvement
> Components: File Formats, Metastore
> Reporter: Simon AUBERT
> Priority: Major
>
> Hello all,
> As of today, when you want to know the file format of every table, you have,
> as far I know, two solutions :
> -a loop in shell
> -a loop in the tool you use for HQL queries, and then parse the answer, etc..
> I think this is way too complicated for such a very basic need. So a
> table_file_format (or partition_file_format, I don't know) in the
> information_schema would be a very precious help for monitoring. It can be
> directly read by a reporting tool (Superset, Tableau, PowerBi, Qlik, whatever
> you want).
> Best regards,
> Simon
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
