Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-22433

Hive JDBC Storage Handler: Incorrect results fetched from BOOLEAN and TIMESTAMP DataType From JDBC Data Source

    XMLWordPrintableJSON

Details

    Description

      Steps to Reproduce:

      //Derby table:
      create table testtbl(a BOOLEAN, b TIMESTAMP);
      
      // Insert to table via mysql connector
      // data in db
      true 2019-11-11 12:00:00
      
      //Hive table:
      CREATE EXTERNAL TABLE `hive_table`(               
            a BOOLEAN, b TIMESTAMP
       )           
          STORED BY                                          
            'org.apache.hive.storage.jdbc.JdbcStorageHandler'                       
          TBLPROPERTIES (                                                            
            'hive.sql.database.type'='DERBY',                                  
            'hive.sql.dbcp.password'='',             
            'hive.sql.dbcp.username'='',             
            'hive.sql.jdbc.driver'='',  
            'hive.sql.jdbc.url'='',  
            'hive.sql.table'='testtbl');
      
      //Hive query:
      select * from hive_table;
      
      // result from select query
      
      false 2019-11-11 20:00:00
      
      

      Attachments

        1. HIVE-22433.01.patch
          1 kB
          Syed Shameerur Rahman
        2. HIVE-22433.02.patch
          6 kB
          Syed Shameerur Rahman
        3. HIVE-22433.03.patch
          6 kB
          Syed Shameerur Rahman
        4. HIVE-22433.04.patch
          6 kB
          Syed Shameerur Rahman
        5. HIVE-22433.05.patch
          6 kB
          Syed Shameerur Rahman

        Issue Links

          Activity

            People

              srahman Syed Shameerur Rahman
              srahman Syed Shameerur Rahman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: