[ 
https://issues.apache.org/jira/browse/HIVE-15519?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Rui Li updated HIVE-15519:
--------------------------
       Resolution: Fixed
    Fix Version/s: 2.2.0
                   1.3.0
           Status: Resolved  (was: Patch Available)

> BitSet not computed properly for ColumnBuffer subset
> ----------------------------------------------------
>
>                 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
>             Fix For: 1.3.0, 2.2.0
>
>         Attachments: data_type_test(1).txt, HIVE-15519.1.patch, 
> HIVE-15519.2.patch, HIVE-15519.3.patch, HIVE-15519.4.patch, 
> HIVE-15519.5-branch-1.patch, HIVE-15519.6.patch
>
>
> Hive decimal type column precision is returning as zero, even though column 
> has precision set.
> Example: col67 decimal(18,2) scale 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, scale 
> is returning as zero.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to