[jira] [Created] (HIVE-24888) JDBC Query with where clause containing timestamp field in long doesn't return any result.

["Anurag Shekhar (Jira)" <ji...@apache.org>]

Anurag Shekhar created HIVE-24888:
-------------------------------------

             Summary: JDBC Query with where clause containing timestamp field in long doesn't return any result.
                 Key: HIVE-24888
                 URL: https://issues.apache.org/jira/browse/HIVE-24888
             Project: Hive
          Issue Type: Bug
          Components: JDBC
            Reporter: Anurag Shekhar


Steps to reproduce

The following code creates a table with timestamp column and inserts a value, using java.sql.PreparedStament.setLong.

When same value used to query the table it returns no results. 

Other variant, using timestamp (setTimestamp) string (setString) works fine.
{code:java}
public static void main(String [] args) throws SQLException {
    TimeZone.setDefault(TimeZone.getTimeZone("IST"));
    Connection conn = DriverManager.getConnection ("jdbc:hive2://host:port", "hive", "hive");
    Statement stmt = conn.createStatement();
    stmt.execute("drop table if exists ts_table");
    stmt.execute("create table ts_table (ts timestamp) stored as orc");
    PreparedStatement pStmt = conn.prepareStatement("insert into ts_table (ts) values (?)");
    long timeStamp = System.currentTimeMillis();
    pStmt.setLong(1, timeStamp);
    pStmt.execute();
    pStmt.close();

    pStmt = conn.prepareStatement("select * from ts_table where ts = ?");
    pStmt.setLong(1, timeStamp);
    ResultSet rs = pStmt.executeQuery();

    if (rs.next()) {
        Timestamp resultTs = rs.getTimestamp(1);
        System.out.println("Retrieved " + resultTs + " In millis " + resultTs.getTime());
        System.out.println("where ts = " + timeStamp);
    }
    else
        System.out.println ("No result where ts = " + timeStamp);

    rs.close();
    pStmt.close();
    conn.close();
}{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)