- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Yogini,
Did you connected to the database for your first select command.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I see lib statement for the first select statement is missing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.