[jira] [Created] (DRILL-5250) Date is stored wrongly in HIVE generated JSON

2017-02-10 Thread Ravan (JIRA) 
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

2017-01-03 Thread Ravan (JIRA) 
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

2016-12-01 Thread Ravan (JIRA) 
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

2016-12-01 Thread Ravan (JIRA) 
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)