how to schedule sqoop import on daily bases

[#1]

hi,

wanted to move rdbms data into hdfs on daily bases using sqoop import.

is there any job shedular avaible in hadoop system which will run sqoop import command on daily bases ?

if  yes then please provide details such as how to set job sheduleing frequency and how to check log if job fails ?

regards

vivek

[#2]

i am using hive now

in sql we have sysdate function and we can play with it like sysdat-1. sysdate-2

in hive

current_date is there, is there way we can write like current_date-1

while using current_date -1 . it shows error 

FAILED: SemanticException [Error 10014]: Line 1:7 Wrong arguments '1': No matching method for class org.apache.hadoop.hive.ql.udf.generic.GenericUDFOPDTIMinus with (date, int)

regards

vivek

[#3]

Hi,

As this is a different issue, I would request to open a new thread because there are multiple issues that has been discussed over here which is making this thread more complicating.

I would request to open a new thread and kindly share the link so we can work on it.

Regards

Nitish

[#4]

you are right.

[#5]

will you please guide me how to create new post since i am new to community

[#6]

Hi @vivek_rol,

To create a new post on the community you would first go to the appropriate board, such as Data Ingest which is where this thread is. Then at the top left of the board you will see a button named "New Message".

Click the button, fill out the fields and hit the post button to start a new thread. 

[#7]

Thanls lot