Hi Peter,
Could you please also share a stacktrace?
Does the specified table
contain pan, terminal_id, source_node_name, tran_completed, tran_reversed
and tran_type columns? If it contains them, which types do they have?
Kind regards,
Volodymyr Vysotskyi
пт, 27 квіт. 2018 о 17:47 Peter Edike
Drill Version 1.12.0
planner.enable_decimal_data_type is set to true on the system.
--peter
-Original Message-
From: Andries Engelbrecht
Sent: Friday, April 27, 2018 3:41 PM
To: user@drill.apache.org
Subject: Re: Exception While Querying Decimal Fields in
What version of Drill are you using?
Also is planner.enable_decimal_data_type set to true on the system?
--Andries
On 4/27/18, 7:24 AM, "Peter Edike" wrote:
Tried That, It did not work. Still Fails with the exception. Let me even
add that even if the query is a simple select from stat
Tried That, It did not work. Still Fails with the exception. Let me even add
that even if the query is a simple select from statement, as long any of
the fields is decimal type, the statement will fail with the stated exception
Please Help a lot depends on this
Best regards,
Peter Edike
Perhaps try to convert the predicate and select operations involving the
decimal types to float or similar.
i.e tran_completed = 1.0 and ((cast(SETTLE_AMOUNT_IMPACT as double)
*(-1.0))/100.0)
Alternatively you may have to cast the decimals as float, but that will be more
cumbersome.
--Andri
I am trying to run the following query in apache drill, I am querying data
stored in parquet files using the following query
select pan, count(*) as number_of_transactions ,
terminal_id,SUM((cast(SETTLE_AMOUNT_IMPACT as double) *-1)/100) AS
settle_amount_impact
from dfs.`/iswdata/storage/prod
