Bharat Viswanadham created HIVE-15519:
-----------------------------------------
Summary: 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
Hive decimal column precision is returning as zero, even though column has
precsion set.
Example: col67 decimal(18,2) precison is returning as zero for that column.
Tried with below program.
System.out.println("Opening connection");
Class.forName("org.apache.hive.jdbc.HiveDriver");
System.out.println("hi");
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();
;
}
Default fetch size is 50. if any columns 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)
