Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
gabriele_qlik
Contributor III
Contributor III

FIELD NOT FOUND!!!!

Hi at all,

I have connected Hive to Qlik Sense to load a table. The problem is that qlik don't find the field of the table. I have worked other times with hive connector but this is the first time that I have this problem. in the following three picture is descripted my problem.

Solution?

Thank you

table.png

script.png

field not found.png

1 Solution

Accepted Solutions
mdmukramali
Specialist III
Specialist III

Hi,

Can you try something like this

Load *;

SQL SELECT * from

connection ;



View solution in original post

5 Replies
ogautier62
Specialist II
Specialist II

Hi,

data seems to be a key word reserved name,

try another name for field

regards

mdmukramali
Specialist III
Specialist III

Hi,

Can you try something like this

Load *;

SQL SELECT * from

connection ;



gabriele_qlik
Contributor III
Contributor III
Author

Thank you. If I insert * in load and sql statement there aren't errors.

Simple solutions are the better

Thank you

gabriele_qlik
Contributor III
Contributor III
Author

I used Load * and sql select * to resolve the problem. But if I try to insert to first place another field there is the error: Field not found... I don't know why

Albert
Contributor
Contributor

Hi everyone,

so I had a similar problem in my load script. It seems, that when the column names of the table you want to select and load contains any reserved keywords, the names will be qualified. In my case, I was able to load those columns/fields by using `my_table.my_column`. Note that the table having those columns triggers this, not you loading those specific columns.