Member since
02-05-2018
3
Posts
1
Kudos Received
0
Solutions
02-15-2018
04:23 AM
Hi All, I am trying to automatise the testing of the data in Impala. Is there a way to check, if two columns from the different tables have the same data type? Currently we are doing this check manually, by describe formatted a;
describe formatted b; but I would like to see result in the way: select
case
when a.type = b.type
then "TRUE"
else "FALSE"
end
from
(describe formatted x.column1 as type) a,
(describe formatted y.column1 as type) b; Can you please advise, if there is a way to implement second example? Thanks, Anastasia
... View more
Labels:
- Labels:
-
Impala
02-05-2018
11:59 AM
1 Kudo
Thank you a lot for quick response! -------EDIT---------- Also, I have found a possible walk around with using split_part() function instead of substr() - it will work for my particular case
... View more
02-05-2018
08:53 AM
Hi, I've upgraded Impala from 2.7.0 to 2.9.0 and one of my queries stopped working after that. On running this query: select first_value(transxref) over (partition by substr(gbm.transxref,1,(instr(gbm.transxref,'/'))-1)
order by substr(gbm.transxref,1,(instr(gbm.transxref,'/'))-1), reportdate)
from gbm_partition gbm I receive error: "IllegalStateException: null" But if I will change order by clause and will run query below - it will work. select first_value(transxref) over (partition by substr(gbm.transxref,1,(instr(gbm.transxref,'/'))-1)
order by transxref, reportdate)
from gbm_partition gbm 1. Can anybody please suggest, if there are any incompatibilities between 2.7.0 and 2.9.0 (I haven't found anything in Release Notes)? 2. If there are - can anybody please suggest a workaround for this issue? Thanks in advance, Anastasiia
... View more
Labels:
- Labels:
-
Impala