Import Job setup
HI,
I have watched many videos and read a number of blog posts but I am at a loss as to what I need to put in the import job. My data sits on a data lake, so do I just cut and paste the HQL that I would normally use to get an extract out? Can someone please advise? Thank you very much for your time.
ADC
-
Hi there! Since you mention HQL, I assume that you're interested in the recently released JDBC Generic (Hive Server2) configuration. The steps are outlined in that link to our documentation.
In summary, you'll need a Connection (to Hive's JDBC capabilities) artifact in Datameer. Once you have access to this JDBC Hive Server 2 Connection, you'll be able to create the next artifact. After that, create the Import Job and specify the HQL into the "Enter SQL Statement" option on the "Data Details" step.
If you're not looking for the JDBC equivalent, we have other Hive connections built into the product as well that can bring in Hive tables fully. These are outlined in our documentation here: Hive
Hope this helps!
Please sign in to leave a comment.
Comments
2 comments