Separate names with a comma.
Recommended. Know people from your network.
Don't have an account?Sign up Now
To reset your password, enter the email address you registered with and we"ll send your instructions on their way.
Discussion in 'Big Data and Analytics' started by Neha_Pandey, Mar 26, 2019.
Kindly post your queries below.
Can anyone able to create dataset in your webconsole?
I have uploaded following to google drive.
1) SQOOP and Map reduce command line interface command file covering all that I demoed
2) 2 assignments on map reduce for those who are interested
3) you will already have HDFS/MYSQL assignment from last week so please complete those
4) Java code for map reduce with needed input files:
-- reduce side join
-- composite join
I cannot find the "team_statistics" folder as mentioned in the MapReduce assignment document. Can you tell me exactly where it it? Thanks
I unable to setup the sandbox becoz of system limitations.
But i setup the eclipse and exported the jar file
how to execute it??
1) Copy the jar file to LMS
2) Run below command from LMS Linux window:
$hadoop jar <give your jar file name> <java package.class name> <Input file path of HDFS> <Output folder path of HDFS>
Let me know if this helps. I will check again tomorrow evening.
I now remember, that team_statistics was more of a reference solution to solve retail problem. I have now added the player_statistics,csv file and also the java code to calculate team_statistics in the google drive. please refer the same.
Titanic data provided for assignment contains a Field called Passenger Name,
that name contains comma in between but surrounded by quotes, with that i able to identify this full name
but while loading into table, creates improper data because of that comma
I am not able to update sql table with titanic data. Please see attached notepad. Can you please help?
I am not able to update sql table with titanic data. Please see attached notepad. Can you please help? forgot to attach the file before.
You need to create the table in hive not in MYSQL. All the load commands are for Hive.
That is correct. It was intentional and expectation is to use hive built in string function to remove the additional comma from passenger name field.
Functions that will help you remove the additional comma: regexp_replace and regexp_extract.
I will share the solution this weekend.
Is there any assignment for this week on spark ?
Is there a difference in CCA159 and CCA175 in the way job market is looking ?
level of effort , time, market value ? any pros and cons on either one ?
Didn't find the commands of 28/4/19 class in Drive
Kindly verify and reply
Please let me know that which are the commands you are looking for it so I can share those to your registered email id.
i am trying to import table through sqoop using the following command in terminal in virtual box.
sqoop import --connect jdbc:mysql://localhost/training --username training --password training --table countries;
I am getting this error:
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use n
ear 'sqoop import --connect jdbc:mysql://localhost/training --username training --pas' at line 1
please help me out.