Incremental load from qvd error

[#1]

Hi,

I am new to qlik sense and tryto load data from qvd file. I am using code below

MyQVD:

SQL SELECT [viewstation],

  [viewstationdesc],

  [viewchannel],

  [sdorhd]

FROM panelviewing2 ;

Concatenate LOAD [viewstation],

  [viewstationdesc],

  [viewchannel],

  [sdorhd]

    FROM [lib://Buffers/MyQVD.qvd] ;

I am getting error as "Error in connector reply". Can someone pls help?

Regards,

Yogini

[kkkumar82]

Hi Yogini,

Did you connected to the database for your first select command.

[kkkumar82]

I see lib statement for the first select statement is missing

[#4]

Yes, I have first connected to Hadoop hive statement. The first line is

LIB CONNECT TO [Apache_Hive_10.77.46.23];

where 1.77.46.23 is the hive system server.

[Silambarasan1306]

Hi Try like this,

MyQVD:

LOAD [viewstation],

  [viewstationdesc],

  [viewchannel],

  [sdorhd]

    FROM [lib://Buffers/MyQVD.qvd] ;

SQL SELECT [viewstation],

  [viewstationdesc],

  [viewchannel],

  [sdorhd]

FROM panelviewing2 ;

If the fields are same it will autoconcatanate, no worries. I think the problem is in your database connector. Check with the connection.