Cloudera Community
SatishS
user rank
Expert Contributor

Re: Sqoop import command to overwrite the existing...

by Expert Contributor in Support Questions
‎06-07-2017 03:59 AM
‎06-07-2017 03:59 AM
If the target table is Hive table then you can use -hive-overwrite ... View more

Re: Table location - CREATE TABLE vs. ALTER TABLE....

by Expert Contributor in Support Questions
‎06-07-2017 03:32 AM
‎06-07-2017 03:32 AM
@ozac When you alter the location for hive table, it will not move the data from old location to new location (if any data present). It will only load the data from the new location. The error shows that the required data file is not present. Make sure that the data file is also present in the new location. FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.mr.MapRedTask. cannot find dir =hdfs://sandbox.hortonworks.com:8020/tmp/a2/000000_0_copy_1 in pathToPartitionInfo: [hdfs:/tmp/a2] ... View more

Re: Hive tables are split into files, how can we k...

by Expert Contributor in Support Questions
‎06-07-2017 02:29 AM
‎06-07-2017 02:29 AM
@Stinger It won't give you the file size, but it will give you the path where those files are stored, so you can refer that path for details like file size, permissions, etc. ... View more

Re: Can't store in pig

by Expert Contributor in Support Questions
‎06-07-2017 02:23 AM
‎06-07-2017 02:23 AM
@John Cleveland Can you execute these commands on grunt and let me know the results? It should load file from the mentioned path as part of your LOAD command. ... View more

Re: Hive tables are split into files, how can we k...

by Expert Contributor in Support Questions
‎06-06-2017 07:44 PM
‎06-06-2017 07:44 PM
Access the path where these files are stored to find the size of these split files. You can do a DESCRIBE EXTENDED /FORMATTED Tablename to find the exact path of the files. ... View more

Re: Override default Hive Database Path

by Expert Contributor in Support Questions
‎06-06-2017 02:18 PM
‎06-06-2017 02:18 PM
Could anyone please let me know on this? ... View more

Re: Pig - Load data from two different path

by Expert Contributor in Support Questions
‎06-04-2017 10:15 PM
‎06-04-2017 10:15 PM
@Greg Keys Both source files are in different paths. ... View more

Re: Override default Hive Database Path

by Expert Contributor in Support Questions
‎06-04-2017 09:47 PM
‎06-04-2017 09:47 PM
@Geoffrey Shelton Okot The default path is /apps/hive/warehouse. But, for this database, I have mentioned different path to create and I am am not able to find the .db folder in the mentioned path, I can see the table folder when I create one. The .db folder should be created under the same mentioned path right? ... View more

In which version of Hive the Hiverserver2 is intro...

by Expert Contributor in Support Questions
‎06-04-2017 11:26 AM
‎06-04-2017 11:26 AM
Hi, Could anyone please let me know that in which version of hive the hiveserver 2 is introduced?   ... View more
Labels:

Override Hive Default Path

by Expert Contributor in Support Questions
‎06-04-2017 06:43 AM
‎06-04-2017 06:43 AM
Hi Hive Users,   I have created a Hive database by overrrinding the defailt path as follows, SQL: Create database diff location '/user/cloudera/sat';   After creating this databse, I tried to access this path to see wether it's created a .db folder , but I don't see anything with this name there. Even I created a table in this database and I only see the new folder with name as test.   Not sure why its not crated diff.db folder in this path. Please refer the attached screen shots for more details. Please let me know if i am missing anything here.   ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎06-17-2017 08:10 PM
Community Statistics
Member Since ‎05-15-2017 05:34 PM
Last Visited ‎06-17-2017 08:10 PM
Posts 86
Kudos received 12