[
https://issues.apache.org/jira/browse/HIVE-15519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Rui Li reassigned HIVE-15519:
-----------------------------
Assignee: Rui Li
> Hive Decimal Type column scale is returning as zero
> ---------------------------------------------------
>
> Key: HIVE-15519
> URL: https://issues.apache.org/jira/browse/HIVE-15519
> Project: Hive
> Issue Type: Bug
> Components: Hive, JDBC
> Reporter: Bharat Viswanadham
> Assignee: Rui Li
> Priority: Critical
> Attachments: data_type_test(1).txt
>
>
> Hive decimal type column precision is returning as zero, even though column
> has precision set.
> Example: col67 decimal(18,2) precison is returning as zero for that column.
> Tried with below program.
> {code}
> System.out.println("Opening connection");
> Class.forName("org.apache.hive.jdbc.HiveDriver");
> Connection con =
> DriverManager.getConnection("jdbc:hive2://x.x.x.x:10000/default");
> DatabaseMetaData dbMeta = con.getMetaData();
> ResultSet rs = dbMeta.getColumns(null, "DEFAULT", "data_type_test",null);
> while (rs.next()) {
> if (rs.getString("COLUMN_NAME").equalsIgnoreCase("col48") ||
> rs.getString("COLUMN_NAME").equalsIgnoreCase("col67") ||
> rs.getString("COLUMN_NAME").equalsIgnoreCase("col68") ||
> rs.getString("COLUMN_NAME").equalsIgnoreCase("col122")){
> System.out.println(rs.getString("COLUMN_NAME") + "\t" +
> rs.getString("COLUMN_SIZE") + "\t" + rs.getInt("DECIMAL_DIGITS"));
> }
> }
> rs.close();
> con.close();
> } catch (Exception e) {
> e.printStackTrace();
> ;
> }
> {code}
> Default fetch size is 50. if any column no is under 50 with decimal type,
> precision is returning properly, when the column no is greater than 50,
> precision is returning as zero.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
