Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Getting a error in hive/impala query

avatar
New Contributor

Hi

I am writing hive query on my jupyter notebook. But, an error is coming.

My code is :

query = """" select addr_line1_txt as add1,

addr_line2_txt as add2 

from from int_client_addr

""""

path_file = 'çheck.csv'

df = queryImpalaAndSave(path_file, delimeter,query)

clear_output()

displaydf()

 

error is empty dataerror.

 

Please help!!!

1 REPLY 1

avatar
Master Collaborator

Hi @Anyy ,

 

Your SQL statement seems to be malformed. You have "from" keyword duplicated. Please fix and try running again.

 

If that helps, please accept as solution.

 

 

Regards,

Alex