Member since
01-21-2018
58
Posts
4
Kudos Received
3
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
3224 | 09-23-2017 03:05 AM | |
1497 | 08-31-2017 08:20 PM | |
6050 | 05-15-2017 06:06 PM |
06-05-2017
12:32 PM
thanks , tried and working. I have just to be more careful on my typing. I appriciate.
... View more
06-01-2017
12:25 PM
1 Kudo
You right buddy , actually I have tested creating the primary key in the same table and is just stored one record so this is what happen when we dont count with the primary key. thanks buddy
... View more
06-01-2017
12:16 PM
Hi everyone, I'm trying to perform a grouping for a relation with the scheme below: I have created a the group all for whole relation as: total_station_trips_all = GROUP october ALL; Finally I'm trying to get the counting for the column s_station from the scheme october like Unfortunatelly I'm getting this error: Please guys give me a light about this error i will appreciate so much. Thanks so much. AU
... View more
Labels:
- Labels:
-
Apache Pig
05-30-2017
01:40 AM
Hello everyone, I'll try to be very pointed with my question for easy understanding. So, guys, the thing is that I'm preparing my exam for HDPCD so I'm playing a lot with sqoop. In this case, I have a sample txt file to load data in Mysql. I have done the first load and then I would like to try the properties --update-key and --update-mode allowinsert to join and update my table. I performed a first load data to mysql table and that looks like: so after the first load, I have added new rows and change one row for my column called season in id <10> to <winter> so my file looks now like I executed: sqoop export --connect jdbc:mysql://master/poc --username root --table cours --export-dir /user/hdfs/mysql/export.txt --update-key id --update-mode allowinsert --fields-terminated-by '\t' -m 1 My new table output looks like: That's correct cause the new courses were included and the season change on row id 10 also was updated but instead of update the same row sqoop has added a new column so i think that it should better just really update and not duplicate my id cause what if it's a primary key so guys. do you know how perform the update without duplicate non necessary data?
... View more
Labels:
- Labels:
-
Apache Sqoop
05-25-2017
04:54 PM
No sr, thanks so much for your help @Eyad Garelnabi
... View more
05-24-2017
06:01 PM
I have found that both statements refers to HDFS , so what can i use to put data in local paths, out from HDFS ?
... View more
05-24-2017
05:40 PM
thanks so much @Eyad Garelnabi let me ask you something so if i need to move all tables to HDFS i need to move them first to local and then to HDFS or create one sqoop job by table?? OMG thanks
... View more
05-24-2017
03:39 PM
Hi guys I'm using sqoop to import the data from MySQL to HDFS with the option import-all-tables as below: sqoop import-all-tables --connect jdbc:mysql://master/poc --username root --target-dir /user/hdfs/mysql --mysql-delimiters -m 1 My problem is that i got an error messages regarding the parameter --target-dir is wrong but i have checked the documentation and it's correct , when i run the same but pointing in a local path using --warehouse-dir that works. could someone tell me where I'm wrong? thanks error attached
... View more
Labels:
- Labels:
-
Apache Sqoop
05-17-2017
07:15 PM
Great @Eyad Garelnabi thanks so much that was what I was looking for!!! i will close the question i appreciate.
... View more
05-16-2017
06:44 PM
Oh yeah buddy by i want to specify the DB in hive for the destination i mean something like --hive-database you get me , cause as default all impoted tables in Hive go to default DB . My requirement is set a different DB to put the data. thanks
... View more
- « Previous
- Next »