Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
After loading data using a REST Connector I need to include a WHERE statement as follows, but it's not working. It returns an error that i can't understand. Is it possible to include a WHERE there?
RestConnectorMasterTable:
SQL SELECT
"Status",
"High",
"Low",
"Open"
FROM XML "StockQuote"
WHERE [Status]='SUCCESS';
[StockQuote]:
LOAD [Status],
[High],
[Low],
[Open]
RESIDENT RestConnectorMasterTable;
DROP TABLE RestConnectorMasterTable;
I've tried many options, please, help.
Thanks,
Alazne.
Try below
1 : RestConnectorMasterTable:
Load * Where Status='SUCCESS';
SQL SELECT
"Status",
"High",
"Low",
"Open"
FROM XML "StockQuote"
WHERE [Status]='SUCCESS';
2:
SQL SELECT
"Status",
"High",
"Low",
"Open"
FROM XML "StockQuote";
[StockQuote]:
LOAD [Status],
[High],
[Low],
[Open]
RESIDENT RestConnectorMasterTable
where Status = 'SUCCESS';
DROP TABLE RestConnectorMasterTable;
Regards,
Thanks, it seems that preceding load works, but i undestand that preceding load filters data after loading it.
What I need, because of the data volume, is to filter data while loading (SQL SELECT) and thus reduce the volume of downloaded data. Is that possible?
Hi,
I did not remember properly Some where I read that you can't write where clause on XML data...
Regards,