Hi I find the solution, now there is no duplicate data occurred. Thank you sqoop import --connect 'jdbc:sqlserver://XX.XXX;database=XXXX' --username XX --password XXXX --table ActionItems --split-by ActionId --target-dir /user/hive/warehouse/project_tracking.db/actionitems --incremental append --check-column Lastupdateddate --last-value "2019-02-06 19:52:55.873" ... View more

sqoop import-all-tables --driver=com.microsoft.sqlserver.jdbc.SQLServerDriver --connect jdbc:sqlserver://XX.XX.XXX:1433; database=PTWTarget --username ML_Testing --password Admin --hive-database PTWTarget --hive-import I tried like this but i'm getting error, please validate my code and provide me solution Error: java.lang.RuntimeException: java.lang.RuntimeException: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host x.x.x.x, port 1433 has failed. Error: "connect timed out. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.". ... View more

Hi I have a Query like this, sqoop import --driver=com.microsoft.sqlserver.jdbc.SQLServerDriver --connect “jdbc:sqlserver://XX.XX.XXX:1433; database=PTWTarget” --username sa --P --table ActionItems --create-hive-tables --target-dir /sqltohive/actionitems --hive-import -m 1 when i execute, i'm getting error in TCP/IP connection had refused. ... View more

Hi Thank you for your reply I tried this method to insert csv data into hbase table that's working fine. My question is, i have a list of flat files i.e,.word, excel, image in my hdfs directory, i want to store all these data into one hbase table as a object. still i didn't get solution for this problem, please provide any suggestions for me. Thank you ... View more

I have these kind of unstructured data stored in HDFS, Please provide the suggestion to load these unstructured data into HBase table to view the data. ... View more