[
https://issues.apache.org/jira/browse/TRAFODION-2363?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15687354#comment-15687354
]
ASF GitHub Bot commented on TRAFODION-2363:
-------------------------------------------
Github user DaveBirdsall commented on a diff in the pull request:
https://github.com/apache/incubator-trafodion/pull/846#discussion_r89167830
--- Diff: core/sql/comexe/ComTdbExeUtil.h ---
@@ -2946,37 +2946,65 @@ class ComTdbExeUtilLobShowddl : public ComTdbExeUtil
static const ComTdbVirtTableColumnInfo hiveMDTablesColInfo[] =
{
- { "CATALOG_NAME", 0, COM_USER_COLUMN, REC_BYTE_F_ASCII, 256,
FALSE , SQLCHARSETCODE_UNKNOWN, 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT, ""
,NULL,NULL,COM_UNKNOWN_DIRECTION_LIT, 0},
- { "SCHEMA_NAME", 1, COM_USER_COLUMN, REC_BYTE_F_ASCII, 256,
FALSE , SQLCHARSETCODE_UNKNOWN, 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT, ""
,NULL,NULL,COM_UNKNOWN_DIRECTION_LIT, 0},
- { "TABLE_NAME", 2, COM_USER_COLUMN, REC_BYTE_F_ASCII, 256,
FALSE , SQLCHARSETCODE_UNKNOWN, 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT,
"",NULL,NULL,COM_UNKNOWN_DIRECTION_LIT, 0}
+ { "CATALOG_NAME", 0, COM_USER_COLUMN, REC_BYTE_F_ASCII, 256,
FALSE , SQLCHARSETCODE_UTF8, 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT, ""
,NULL,NULL,COM_UNKNOWN_DIRECTION_LIT, 0},
+ { "SCHEMA_NAME", 1, COM_USER_COLUMN, REC_BYTE_F_ASCII, 256,
FALSE , SQLCHARSETCODE_UTF8, 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT, ""
,NULL,NULL,COM_UNKNOWN_DIRECTION_LIT, 0},
+ { "TABLE_NAME", 2, COM_USER_COLUMN, REC_BYTE_F_ASCII, 256,
FALSE , SQLCHARSETCODE_UTF8, 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT, ""
,NULL,NULL,COM_UNKNOWN_DIRECTION_LIT, 0},
+ { "FILE_FORMAT", 3, COM_USER_COLUMN, REC_BYTE_F_ASCII, 24,
FALSE , SQLCHARSETCODE_ISO88591, 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT, ""
,NULL,NULL,COM_UNKNOWN_DIRECTION_LIT, 0},
+ { "CREATE_TIME", 4, COM_USER_COLUMN, REC_BIN64_SIGNED, 8,
FALSE , SQLCHARSETCODE_UNKNOWN, 0, 0, 0, 0, 0, 0, 0, COM_NO_DEFAULT, ""
,NULL,NULL,COM_UNKNOWN_DIRECTION_LIT, 0},
--- End diff --
Why do we use LARGEINT for times instead of TIMESTAMP? (Yes, I know we do
this too in our metadata.)
> Add support to return metadata info about hive tables in relational format
> --------------------------------------------------------------------------
>
> Key: TRAFODION-2363
> URL: https://issues.apache.org/jira/browse/TRAFODION-2363
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Anoop Sharma
> Assignee: Anoop Sharma
> Priority: Minor
>
> Metadata info about trafodion tables and columns can be retrieved by
> running sql queries against traf metadata tables/views from "_MD_" schema.
> This jira is for an enhancement to return metadata info about hive
> tables/columns in relational format using traf queries.
>
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
