FIELD NOT FOUND!!!!

[gabriele_qlik]

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

[ogautier62]

Hi,

data seems to be a key word reserved name,

try another name for field

regards

[mdmukramali · Accepted solution]

Hi,

Can you try something like this

Load *;

SQL SELECT * from

connection ;

[gabriele_qlik]

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

Simple solutions are the better

Thank you

[gabriele_qlik]

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]

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.