sbhaskar85
New Contributor II
Joined 7 years ago
User Profile
User Widgets
Contributions
Not able to configure ORC writer with Hive Metastore URL
We are trying to write data into HDFS as ORC file. There is a ORC writer snap that is available for Standard Mode pipelines. The Snap configuration requires Hive Metastore URL. When we are providing the URL, the snap is throwing the below validation error We have validated the Thrift URL and it seems to be correct. Any leads on what could be the issue here. Note: Our Hadoop is Kerberos enabled2.7KViews0likes2CommentsHow to set dependencies in SnapLogic
Hi Have 3 pipelines Pipeline-1, Pipeline-2, Pipeline-3. The execution logic is as follows Pipeline-1 and Pipeline-2 executes parallely and once both of them are success, then only the Pipeline-3 would be triggered. Looking for suggestions regarding this. Thanks in advance3.4KViews0likes2CommentsHow to replace NULL value in Mapper
I have a file reader in my mapping. One of the column in the file contains NULL value. I am connection a mapper after the file reader. Is there any way to replace the NULL value with number? Tried using replace/replaceALL function but didn’t get the intended result9.4KViews0likes2CommentsTranspose Table data to XML format
Input data(4 rows): Employee ID Type EmployeeID Address ID Address Employee_ID A001 1 test1 Employee_ID A001 2 test2 Employee_ID A002 1 test3 Employee_ID A002 2 test4 Output data(2 rows): <bsvc:Worker_Reference bsvc:Descriptor=“”> <bsvc:ID bsvc:type=“Employee_ID”> A001</bsvc:ID> <bsvc: Address>test1</ bsvc:Address> <bsvc: Address>test2</ bsvc:Address> </bsvc:Worker_Reference> <bsvc:Worker_Reference bsvc:Descriptor=“”> <bsvc:ID bsvc:type=“Employee_ID”> A002</bsvc:ID> <bsvc: Address>test3</ bsvc:Address> <bsvc: Address>test4</ bsvc:Address> </bsvc:Worker_Reference> How to put above data(4 rows) to 2 group of data and use workday write/soap execute to load the data?3KViews0likes1Comment