question upto what level of dot notations can be tried in Impala query formation in Support Questions

upto what level of dot notations can be tried in Impala query formation

Ravi — Wed, 03 Nov 2021 02:18:11 GMT

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.

Re: upto what level of dot notations can be tried in Impala query formation

BennyZ — Wed, 10 Nov 2021 07:17:28 GMT

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

Re: upto what level of dot notations can be tried in Impala query formation

VidyaSargur — Mon, 15 Nov 2021 05:00:24 GMT

@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.