[ 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)