[
https://issues.apache.org/jira/browse/HIVE-21270?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16768059#comment-16768059
]
Shubham Chaurasia edited comment on HIVE-21270 at 2/14/19 10:20 AM:
--------------------------------------------------------------------
This can be in UDTF can be executed as
{code:java}
SELECT GET_SCHEMA("<Some_Query>"){code}
was (Author: shubhamchaurasia):
This can be in UDTF can be executed as \{{SELECT GET_SCHEMA("<Some_Query>")}}
> A UDTF to show schema (column names and types) of given query
> -------------------------------------------------------------
>
> Key: HIVE-21270
> URL: https://issues.apache.org/jira/browse/HIVE-21270
> Project: Hive
> Issue Type: New Feature
> Components: UDF
> Reporter: Shubham Chaurasia
> Assignee: Shubham Chaurasia
> Priority: Major
> Labels: pull-request-available
> Attachments: HIVE-21270.1.patch
>
> Time Spent: 10m
> Remaining Estimate: 0h
>
> We can get ResultSet metadata using {{ResultSet#getMetaData()}}but JDBC
> provides no way of getting nested data types(of columns) associated with it.
> This UDTF helps to retrieve each column name and it's data type.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
