Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Incremental load from qvd error

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

4 Replies
kkkumar82
Not applicable

Re: Incremental load from qvd error

Hi Yogini,

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

kkkumar82
Not applicable

Re: Incremental load from qvd error

I see lib statement for the first select statement is missing

Not applicable

Re: Incremental load from qvd error

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
Not applicable

Re: Incremental load from qvd error

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.