[jira] [Created] (DRILL-5250) Date is stored wrongly in HIVE generated JSON
Ravan created DRILL-5250: Summary: Date is stored wrongly in HIVE generated JSON Key: DRILL-5250 URL: https://issues.apache.org/jira/browse/DRILL-5250 Project: Apache Drill Issue Type: Bug Components: Storage - JSON Affects Versions: 1.8.0 Reporter: Ravan Query1: Connected to Oracle Database select a1.empno,a1.HIREDATE as HIREDATE,a1.SAL as SAL from orcl.xx.EMP a1; Output:- EMPNO HIREDATESAL 7369.0 1980-12-17T00:00:00.000+05:30 800.0 7499.0 1981-02-20T00:00:00.000+05:30 1600.0 7521.0 1981-02-22T00:00:00.000+05:30 1250.0 7566.0 1981-04-02T00:00:00.000+05:30 2975.0 Query2: Creating a hive table with above query and storage format is JSON create table intermediate.HIVE.test_16 as select a1.empno as EMPNO,a1.HIREDATE as HIREDATE,a1.SAL as SAL from orcl.xx.EMP a1; Query 3: SELECT * FROM intermediate.HIVE.test_16 Output: EMPNO HIREDATE SAL 7369.0 1980-12-16 18:30:00.000 800.0 7499.0 1981-02-19 18:30:00.000 1600.0 7521.0 1981-02-21 18:30:00.000 1250.0 7566.0 1981-04-01 18:30:00.000 2975.0 -- This message was sent by Atlassian JIRA (v6.3.15#6346)
[jira] [Created] (DRILL-5175) Unable to Query a table has special characters
Ravan created DRILL-5175: Summary: Unable to Query a table has special characters Key: DRILL-5175 URL: https://issues.apache.org/jira/browse/DRILL-5175 Project: Apache Drill Issue Type: Bug Components: Query Planning & Optimization Affects Versions: 1.8.0 Reporter: Ravan -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (DRILL-5096) Query return null rows .., parquet file creation failed
Ravan created DRILL-5096: Summary: Query return null rows .., parquet file creation failed Key: DRILL-5096 URL: https://issues.apache.org/jira/browse/DRILL-5096 Project: Apache Drill Issue Type: Bug Reporter: Ravan Fix For: 1.8.0 -- This message was sent by Atlassian JIRA (v6.3.4#6332)
[jira] [Created] (DRILL-5095) Selecting Join Columns returning null values in the second column
Ravan created DRILL-5095: Summary: Selecting Join Columns returning null values in the second column Key: DRILL-5095 URL: https://issues.apache.org/jira/browse/DRILL-5095 Project: Apache Drill Issue Type: Bug Affects Versions: 1.8.0 Reporter: Ravan select a.empno,a.ename,a.deptno,b.deptno deptno deptno_1,b.loc from emp a FULL JOIN dept b ON a.deptno = b.deptno Returning O/P:- empno ename deptno deptno_1 loc 7369.0 SMITH 20.0nullDALLAS 7499.0 ALLEN 30.0nullCHICAGO Estimated O/P:- empno ename deptno deptno_1 loc 7369.0 SMITH 20.020.0DALLAS 7499.0 ALLEN 30.030.0CHICAGO -- This message was sent by Atlassian JIRA (v6.3.4#6332)