Member since
08-10-2017
7
Posts
0
Kudos Received
0
Solutions
10-31-2017
04:59 AM
Thankyou @kgautam for this information. It will be helpful if you suggest me any other way through which I can get the data in correct row sequence in hive table through PIG.
... View more
10-30-2017
02:35 PM
Two csv sheet data is loaded into the pig and applied the union operation on that and below is the command with its output in PIG command-in-pig.png pig-output.png but while storing this output
from pig into hive table which I have already created,the data is not coming in correct order and below are the result of that pig output in hive table hive-output.png
... View more
Labels:
- Labels:
-
Apache HCatalog
-
Apache Hive
-
Apache Pig
08-16-2017
07:32 AM
I have downloaded the above driver and in that inside jre8 sqljdbc42.jar file is available and i copied that jar file to sqoop/lib location and when i again wrote the sqoop import command to load the data from sql server to hive still I'm getting the same error that jre version 1.8 is not supported by this driver . use sqljdbc4.jar @mbalakrishnan , i have downloaded the above driver sqljdbc4.2 and in that for jre8 sqljdbc42.jar file is available and when i copy that jar file to sqoop/lib location still I'm getting the same error @mbalakrishnan
... View more
08-10-2017
09:47 AM
I have used the export command to set the classpath .As you can see in the screenshot that in the particular classpath that sqljdbc4.jar file is present but still I am getting the same error screenshot-10.png
... View more
08-10-2017
08:50 AM
Already that jar file is present screenshot-8.png
... View more
08-10-2017
06:57 AM
screenshot-6.pngWhile writing a sqoop import command to load the data from sql server to hive error is coming as use sqljdbc4.jar ..But this jar file is already available .It is HDP 2.6
... View more
Labels: