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

[#1]

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.

[#2 · Accepted solution]

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

[#3]

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