[
https://issues.apache.org/jira/browse/HIVE-11753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Yaqiong resolved HIVE-11753.
----------------------------
Resolution: Won't Fix
Fix Version/s: 0.14.1
The issue was fixed in 0.14.1, however according to HIVE-5847, it was fixed in
0.14.0
> DatabaseMetadata.getColumn returns precision 0 for varchar/decimal
> ------------------------------------------------------------------
>
> Key: HIVE-11753
> URL: https://issues.apache.org/jira/browse/HIVE-11753
> Project: Hive
> Issue Type: Bug
> Components: JDBC
> Affects Versions: 0.14.0
> Reporter: Yaqiong
> Fix For: 0.14.1
>
> Original Estimate: 96h
> Remaining Estimate: 96h
>
> I hit same error as HIVE-5847 and HIVE-10933. JDBC version is
> hive-jdbc-0.14.0.2.2.4.2-2-standalone.jar.
> My test program as below:
> /*************************************** test.java
> **********************************************/
> import java.sql.SQLException;
> import java.sql.Connection;
> import java.sql.ResultSet;
> import java.sql.Statement;
> import java.sql.DriverManager;
> import java.lang.*;
> import java.sql.DatabaseMetaData;
> import java.sql.ResultSetMetaData;
> public class test {
> private static String driverName = "org.apache.hive.jdbc.HiveDriver";
> /**
> * @param args
> * @throws SQLException
> */
> public static void main(String[] args) throws SQLException {
> try {
> Class.forName(driverName);
> } catch (ClassNotFoundException e) {
> // TODO Auto-generated catch block
> e.printStackTrace();
> System.exit(1);
> }
> //replace "hive" here with the name of the user the queries should run as
> Connection con =
> DriverManager.getConnection("jdbc:hive2://<hive_server_address>:10001/default",
> "hadoop", "");
> Statement stmt = con.createStatement();
> String tableName = "test";
> stmt.execute("drop table if exists " + tableName);
> stmt.execute("create table " + tableName + " (key varchar(10)) row
> format delimited fields terminated by '\t'");
> ResultSet res = con.getMetaData().getColumns(null, "default", "test",
> null);
> while (res.next()) {
> System.out.println("COLUMN_NAME: " + res.getString(4));
> System.out.println("COLUMN_PRECISION: " + res.getString(7));
> }
> }
> }
> Resutl
> ------------------
> COLUMN_NAME: key
> COLUMN_PRECISION: null
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)