technical details
lab technical issues queries and answers
Here is the information about mysql database Hostname: nn01.itversity.com 2 Username: retail_dba Password: itversity Available databases : ------...
Mon, 29 Jul, 2019 at 5:24 PM
No !! ,you cannot run " create database " query in mysql , as we revoked create database access to the users . please use any one of the availabl...
Mon, 29 Jul, 2019 at 5:26 PM
Issue: When I try to create a database in MySQL I’m getting Access denied. Solution: Users don’t have permission to create a database. They ...
Mon, 29 Jul, 2019 at 5:31 PM
sqoop eval --connect "jdbc:mysql://nn01.itversity.com:3306/retail_export" --username retail_dba --password itversity --query "select o.order_...
Mon, 29 Jul, 2019 at 6:29 PM
As part of this section, we will see how to set up the Hive in the Cloudera distribution. We will also understand important concepts related to Hive. Setu...
Mon, 29 Jul, 2019 at 11:33 PM
Does the .hiverc execute globally or is there a .hiverc file for each user? I would like to set the folllowing variables for my Hive sessions set hive.cl...
Mon, 29 Jul, 2019 at 11:36 PM
While importing data from Mysql to HDFS with 10 mappers but i want to store a single mapper only. How can we solve this? syntax sqoop import --connect jdb...
Mon, 29 Jul, 2019 at 11:45 PM
Let us understand how to compress the data while importing data using sqoop import We can enable the compression by using –compress Default compressio...
Mon, 29 Jul, 2019 at 11:47 PM
As we have created password file, let us understand how to create sqoop job. We can use sqoop job --create to create the job. Typically we create jobs ...
Mon, 29 Jul, 2019 at 11:49 PM
Let us understand how to filter while importing the data using --where. By default, sqoop import will fetch all the rows in the specified table. If we ...
Mon, 29 Jul, 2019 at 11:51 PM