topic hadoop loading into qlkview in QlikView https://community.qlik.com/t5/QlikView/hadoop-loading-into-qlkview/m-p/1343748#M822336 <HTML><HEAD></HEAD><BODY><P>I am loading data from&nbsp; hadoop database , while loading from database and storing into qvd i am getting the below eror</P><P></P><P> <SPAN class="left" style="color: #000000; font-family: Segoe UI; font-size: 9pt;">SQL##f - SqlState: S1000, ErrorCode: 80, ErrorMsg: [Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 2:49 Invalid table alias or column reference 'P': (possible column names are: id,&nbsp; no, summary, description, status,&nbsp; open_date, time_spent_sum, last_mod_dt, last_mod_by, close_date, resolve_date,&nbsp; assignee, group_id, customer<BR />SQL SELECT *<BR />FROM HIVE.attunity.`call_req` where `call_req`.type = `P`&nbsp; </SPAN>&nbsp; </P><TABLE></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT qlikapple 2020-11-25T16:16:04Z hadoop loading into qlkview https://community.qlik.com/t5/QlikView/hadoop-loading-into-qlkview/m-p/1343748#M822336 <HTML><HEAD></HEAD><BODY><P>I am loading data from&nbsp; hadoop database , while loading from database and storing into qvd i am getting the below eror</P><P></P><P> <SPAN class="left" style="color: #000000; font-family: Segoe UI; font-size: 9pt;">SQL##f - SqlState: S1000, ErrorCode: 80, ErrorMsg: [Hortonworks][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 2:49 Invalid table alias or column reference 'P': (possible column names are: id,&nbsp; no, summary, description, status,&nbsp; open_date, time_spent_sum, last_mod_dt, last_mod_by, close_date, resolve_date,&nbsp; assignee, group_id, customer<BR />SQL SELECT *<BR />FROM HIVE.attunity.`call_req` where `call_req`.type = `P`&nbsp; </SPAN>&nbsp; </P><TABLE></TABLE></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/hadoop-loading-into-qlkview/m-p/1343748#M822336 qlikapple 2020-11-25T16:16:04Z