Created 11-02-2021 07:18 PM
we need to query an array of struct and we can see that more than 1 level of dots are not accepted in the SQL query and it throws error when such queries are executed.
e.g., select abc, def, a1.b1 from xxx where so n so --> This query executes successfully.
but the following:
e.g., select abc, def, a1.b1.c1 from xxx where so n so --> This query fails irrespective of us defining the correct arguments in the from section.
-------------------------------
Can someone tell how many such levels of dot notations are allowed/supported in Impala. I was unable to find any Impala document which was explaining this.
Created on 11-09-2021 11:03 PM - edited 11-09-2021 11:17 PM
Hope the below document can answer your question.
https://impala.apache.org/docs/build/html/topics/impala_struct.html
It looks like we have to change the query as below:
select abc, def, b1.c1 from xxx, xxx.a1 where so n so
Created on 11-09-2021 11:03 PM - edited 11-09-2021 11:17 PM
Hope the below document can answer your question.
https://impala.apache.org/docs/build/html/topics/impala_struct.html
It looks like we have to change the query as below:
select abc, def, b1.c1 from xxx, xxx.a1 where so n so
Created 11-14-2021 09:00 PM
@Ravi, Has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.
Regards,
Vidya Sargur,