Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I'm using QlickSense and facing an error when using applymap on mapping as below:
My script for the mapping is:
MapdestinationAddresstoBookType:
Mapping LOAD
destinationaddr,
BookType
FROM [lib://1.4/BookSales.csv];
ODBC CONNECT TO 'Hive TEST' (XUserId is xxx, XPassword is xxx);
LOAD *,
ApplyMap('MapdestinationAddresstoBookType', destinationaddr, null()) as BookType
FROM HIVE."default"."testv2_view";
Your feedback and assistance is highly appreciated.
Best regards,
Kamarul
Try this
MapdestinationAddresstoBookType:
Mapping LOAD
destinationaddr,
BookType
FROM [lib://1.4/BookSales.csv];
ODBC CONNECT TO 'Hive TEST' (XUserId is xxx, XPassword is xxx);
LOAD *,
ApplyMap('MapdestinationAddresstoBookType', destinationaddr, null()) as BookType;
SELECT *
FROM HIVE."default"."testv2_view";
Hi Sasi,
Thanks for your prompt reply, much appreciated.
I have to do the script that you give but still have no luck. Please find below screen captured:
Thanks and Regards,
Kamarul
Your select statement is missing in ur table that u r loading from some database
Your ODBC connection string is not accepting the username and password there might be some gap in your connection string
create a new connection string and check the same
Try this script
MapdestinationAddresstoBookType:
Mapping LOAD
destinationaddr,
BookType
FROM [lib://1.4/BookSales.csv];
LIB CONNECT TO 'Hive TEST' ;
LOAD *,
ApplyMap('MapdestinationAddresstoBookType', destinationaddr, null()) as BookType;
SELECT *
FROM HIVE."default"."testv2_view";
because you are executing this from qliksense so you should use LIB here and
also please check the connection of the above mapping load,