Custom SQL in Qliksense

Anonymous — Mon, 26 Jan 2026 16:26:21 GMT

Hi ,

I have connected to the hive and enabled i.e i have chosen the tables which i want to use. And i am trying to write an custom sql in load data editor but its throwing error like table not found.

Can anyone help me out?

Query which i used is as below.

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;-$#,##0.00';

SET TimeFormat='h:mm:ss TT';

SET DateFormat='M/D/YYYY';

SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

SET FirstWeekDay=6;

SET BrokenWeeks=1;

SET ReferenceDay=0;

SET FirstMonthOfYear=1;

SET CollationLocale='en-US';

SET CreateSearchIndexOnReload=1;

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET LongMonthNames='January;February;March;April;May;June;July;August;September;October;November;December';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

SET LongDayNames='Monday;Tuesday;Wednesday;Thursday;Friday;Saturday;Sunday';

LIB CONNECT TO 'Apache_Hive_**.**.*.***';

SELECT BOEPI.BILL_SIZE,

DECODE(EPI.patient_type, '1', 'IP', '2', 'OP', '3', 'DC', '4', 'ED', EPI.patient_type ) PatientType,

EPI.ADMIT_STATUS,EPI.ADMISSION_DATETIME,EPI.DISCHARGE_DATETIME,NAT.code_description AS NATIONALITY

FROM FSCGKK.FDEPISODE EPI

INNER JOIN FSCGKK.BOEPISODEACCOUNT BOEPI ON EPI.episode_no=BOEPI.episode_no

INNER JOIN FSCGKK.FDPATIENT PAT ON EPI.fdpatient_id=PAT.fdpatient_id

INNER JOIN FSCGKK.FDPERSON PER ON PAT.fdperson_id=PER.fdperson_id

LEFT JOIN FSCGKK.VW_NAT NAT ON PER.nationality=NAT.code

WHERE NAT.code_description NOT LIKE '%MALAYSIA%'

AND EPI.ADMIT_STATUS IN ('4','IC');

Error:

The following error occurred:

Connector reply error: Unable to get column information for the fields that are used in the query: ERROR [42S02] [Qlik][ODBC Apache Hive Wire Protocol driver][Apache Hive]Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 6:11 Table not found 'FDPATIENT'

topic Custom SQL in Qliksense in QlikView

Custom SQL in Qliksense