Support Questions

Find answers, ask questions, and share your expertise

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

avatar
New Contributor

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.

1 ACCEPTED SOLUTION

avatar
Expert Contributor

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

View solution in original post

2 REPLIES 2

avatar
Expert Contributor

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

avatar
Community Manager

@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,
Community Manager


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: