Hi, I need some guidance on how to bring data from Hive Tables into Lens. The tables are storing data in ORC format. What I have been able to do, is point the HDFS data file locations and use them in Lens Storage specs. This is working for delimited files but not for Orc or other formats.
Can you please provide some reference/guidance on following: 1. How to integrate Hive Tables with custom Serde / Formats a. What customizations to Lens config xmls are needed if any b. Can I do this only via Java Apis? Pls provide the Api link if available c. Or can this be done also via Lens Cli and XMLs? Pls provide the Api link if available 2. How to integrate third party DB like Oracle/Tearadata into Lens a. What customizations to Lens config xmls are needed if any b. Can I do this only via Java Apis? c. Or can this be done also via Lens Cli and XMLs Even if you have relevant links pointing to sources please provide. Thanks for your help as always. Regards Sayantan Raha This e-mail and any files transmitted with it are for the sole use of the intended recipient(s) and may contain confidential and privileged information. If you are not the intended recipient(s), please reply to the sender and destroy all copies of the original message. Any unauthorized review, use, disclosure, dissemination, forwarding, printing or copying of this email, and/or any action taken in reliance on the contents of this e-mail is strictly prohibited and may be unlawful. Where permitted by applicable law, this e-mail and other e-mail communications sent to and from Cognizant e-mail addresses may be monitored.