[jira] [Created] (HIVE-15519) Hive Decimal Type column scale is returning as zero

["Bharat Viswanadham (JIRA)" <ji...@apache.org>]

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)