[
https://issues.apache.org/jira/browse/HIVE-3173?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13793491#comment-13793491
]
N Campbell commented on HIVE-3173:
----------------------------------
Hive 0.11 fails to define prefix and suffix information etc.
TYPE_NAME DATA_TYPE PRECISION LITERAL_PREFIX LITERAL_SUFFIX
CREATE_PARAMS NULLABLE CASE_SENSITIVE SEARCHABLE
UNSIGNED_ATTRIBUTE FIXED_PREC_SCALE AUTO_INCREMENT LOCAL_TYPE_NAME
MINIMUM_SCALE MAXIMUM_SCALE SQL_DATA_TYPE SQL_DATETIME_SUB
NUM_PREC_RADIX
ARRAY 12 [VARCHAR] <null> <null> <null> <null> true false no
support true false false <null> 0 0 <null> <null>
<null>
BIGINT -5 [BIGINT] 19 <null> <null> <null> true false
supports all WHERE false false false <null> 0 0 <null>
<null> 10
BINARY -2 [BINARY] <null> <null> <null> <null> true false
supports all WHERE true false false <null> 0 0 <null>
<null> <null>
BOOLEAN 16 [BOOLEAN] <null> <null> <null> <null> true false
supports all WHERE true false false <null> 0 0 <null>
<null> <null>
DECIMAL 3 [DECIMAL] <null> <null> <null> <null> true false
supports all WHERE false false false <null> 0 0 <null>
<null> <null>
DOUBLE 8 [DOUBLE] 15 <null> <null> <null> true false
supports all WHERE false false false <null> 0 0 <null>
<null> 2
FLOAT 6 [FLOAT] 7 <null> <null> <null> true false
supports all WHERE false false false <null> 0 0 <null>
<null> 2
INT 4 [INTEGER] 10 <null> <null> <null> true false
supports all WHERE false false false <null> 0 0 <null>
<null> 10
MAP 12 [VARCHAR] <null> <null> <null> <null> true false no
support true false false <null> 0 0 <null> <null>
<null>
SMALLINT 5 [SMALLINT] 5 <null> <null> <null> true false
supports all WHERE false false false <null> 0 0 <null>
<null> 10
STRING 12 [VARCHAR] <null> <null> <null> <null> true true
supports all WHERE true false false <null> 0 0 <null>
<null> <null>
STRUCT 12 [VARCHAR] <null> <null> <null> <null> true false no
support true false false <null> 0 0 <null> <null>
<null>
TIMESTAMP 93 [TIMESTAMP] <null> <null> <null> <null> true false
supports all WHERE true false false <null> 0 0 <null>
<null> <null>
TINYINT -6 [TINYINT] 3 <null> <null> <null> true false
supports all WHERE false false false <null> 0 0 <null>
<null> 10
UNIONTYPE 12 [VARCHAR] <null> <null> <null> <null> true false
no support true false false <null> 0 0 <null> <null>
<null>
<null> 12 [VARCHAR] <null> <null> <null> <null> true false no
support true false false <null> 0 0 <null> <null>
<null>
> implement getTypeInfo database metadata method
> -----------------------------------------------
>
> Key: HIVE-3173
> URL: https://issues.apache.org/jira/browse/HIVE-3173
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.8.1
> Reporter: N Campbell
> Attachments: Hive-3173.patch.txt
>
>
> The JDBC driver does not implement the database metadata method getTypeInfo.
> Hence, an application cannot dynamically determine the available type
> information and associated properties.
--
This message was sent by Atlassian JIRA
(v6.1#6144)
