drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5037) NPE in Parquet Decimal Converter
Date Fri, 11 Nov 2016 18:38:58 GMT
Rahul Challapalli created DRILL-5037:
----------------------------------------

             Summary: NPE in Parquet Decimal Converter
                 Key: DRILL-5037
                 URL: https://issues.apache.org/jira/browse/DRILL-5037
             Project: Apache Drill
          Issue Type: Bug
          Components: Storage - Parquet
    Affects Versions: 1.9.0
            Reporter: Rahul Challapalli


git.commit.id.abbrev=4b1902c

In one of our regression runs, I observed that the below query failed. I couldn't reproduce
this issue again.

Query :
{code}
select

				
		count(*)			as count_star,
 		sum(a.d18)		as sum_d18,
 		--round(avg(a.d18))	as round_avg_d18,
 		cast(avg(a.d18) as bigint)	as round_avg_d18,
 		--trunc(avg(a.d18))	as trunc_avg_d18,
 		cast(avg(a.d18) as bigint)	as trunc_avg_d18,
 		--sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as case_in_sum_d18,
 		cast(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end) as bigint) as case_in_sum_d18,
 		--coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as case_in_sum_d18
 		cast(coalesce(sum(case when a.d18 = 0 then 100 else round(a.d18/12) end), 0) as bigint)
as case_in_sum_d18
 
from
 		alltypes_with_nulls a
		left outer join alltypes_with_nulls b on (a.c_integer = b.c_integer)
		left outer join alltypes_with_nulls c on (b.c_integer = c.c_integer)
group by
  		a.c_varchar
 		,b.c_varchar
 		,c.c_varchar
 		,a.c_integer
 		,b.c_integer
 		,c.c_integer
 		,a.d9
 		,b.d9
 		,c.d9
 		,a.d18
 		,b.d18
 		,c.d18
 		,a.d28
 		,b.d28
 		,c.d28
 		,a.d38
 		,b.d38
 		,c.d38
 		,a.c_date
 		,b.c_date
 		,c.c_date
 		,a.c_date
 		,b.c_date
 		,c.c_date
 		,a.c_time

 order by
  		a.c_varchar
 		,b.c_varchar
 		,c.c_varchar
 		,a.c_integer
 		,b.c_integer
 		,c.c_integer
 		,a.d9
 		,b.d9
 		,c.d9
 		,a.d18
 		,b.d18
 		,c.d18
 		,a.d28
 		,b.d28
 		,c.d28
 		,a.d38
 		,b.d38
 		,c.d38
 		,a.c_date
 		,b.c_date
 		,c.c_date
 		,a.c_date
 		,b.c_date
 		,c.c_date
 		,a.c_time
{code}

I attached the data set and error from the log file



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message