Recent questions tagged apache-hive

0 votes
1 answer

How to show all partitions of a table in Hive?

Dec 18, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 4,930 views
+1 vote
2 answers

How to delete and update a record in Hive?

Dec 8, 2020 in Big Data Hadoop by Rajiv
 • 8,910 points • 6,100 views
0 votes
2 answers

How do I output the results of a HiveQL query to CSV?

Nov 20, 2020 in Big Data Hadoop by anonymous
 • 8,910 points • 7,700 views
0 votes
2 answers

How to know Hive and Hadoop versions from command prompt?

Nov 20, 2020 in Big Data Hadoop by Rajiv
 • 8,910 points • 8,753 views
0 votes
1 answer

How to set variables in HIVE scripts

Nov 20, 2020 in Big Data Hadoop by anonymous
 • 10,520 points • 7,183 views
0 votes
1 answer

Drop an index from a Hive table.

Oct 19, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 1,133 views
0 votes
1 answer

How to create an index on Hive table?

Oct 19, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 1,034 views
0 votes
1 answer

Drop a table in Hive.

Oct 19, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 492 views
0 votes
1 answer

How to add a column in Hive table?

Oct 19, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 1,586 views
0 votes
1 answer

How to rename the Hive table?

Oct 19, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 10,917 views
0 votes
1 answer

Create hive table with location.

Oct 16, 2020 in Big Data Hadoop by MD
 • 95,440 points • 421 views
0 votes
1 answer

How to create hive table without location?

Oct 16, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 890 views
0 votes
1 answer

Where does Hive store files in HDFS?

Oct 5, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 708 views
0 votes
1 answer

Can't Pass Java Agent in Hive

Sep 15, 2020 in Big Data Hadoop by Som
 • 140 points • 628 views
0 votes
1 answer

Multiple rows to columns in hive

Sep 4, 2020 in Big Data Hadoop by anonymous
 • 120 points • 2,407 views
+1 vote
1 answer

starting hive gave me exception

May 20, 2020 in Big Data Hadoop by Hans
 • 130 points • 2,077 views
0 votes
1 answer

INFO hdfs.DFSClient: Could not obtain block blk_-from any node: java.io.IOException: No live nodes contain current block

Apr 17, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 2,110 views
0 votes
1 answer

java.io.IOException: File /user/hadoop/ could only be replicated to 0 nodes, instead of 1

Apr 17, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 1,126 views
0 votes
1 answer

exception:org.apache.hadoop.security.AccessControlException Permission denied: user=test, access=WRITE, inode="/user/hive/warehouse/test"

Apr 17, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 3,312 views
0 votes
1 answer

main" java.io.IOException: Mkdirs failed to create /user/hadoop/name.

Apr 17, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 2,193 views
+2 votes
1 answer

FileStreamSink: Error while looking for metadata directory. java.lang.IllegalArgumentException: java.net.UnknownHostException: hive

Feb 13, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 10,592 views
+1 vote
1 answer

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 near 'identified by 'Hivepass70@'' at line 1

Feb 13, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 28,498 views
0 votes
1 answer

ERROR 1819 (HY000): Your password does not satisfy the current policy requirements

Feb 13, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 918 views
0 votes
1 answer

Exception in thread "main" java.lang.IllegalArgumentException: java.net.URISyntaxException: Relative path in absolute URI: ${system:java.io.tmpdir%7D/$%7Bsystem:user.name%7D

Feb 5, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 8,123 views
0 votes
1 answer

org.datanucleus.store.rdbms.exceptions.MissingTableException: Required table missing : "DBS" in Catalog "" Schema "".

Feb 5, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 2,403 views
0 votes
1 answer

Error: FUNCTION 'NUCLEUS_ASCII' already exists.

Feb 5, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 8,730 views
0 votes
1 answer

Exception in thread "main" java.lang.RuntimeException: Hive metastore database is not initialized.

Feb 5, 2020 in Big Data Hadoop by akhtar
 • 38,230 points • 1,345 views
0 votes
1 answer

Caused by: ERROR XJ040: Failed to start database 'metastore_db' with class loader org.apache.spark.sql.hive.client.IsolatedClientLoader$$anon$1@2c7bde26

Feb 3, 2020 in Apache Spark by akhtar
 • 38,230 points • 5,091 views
+1 vote
2 answers

Unable to create external table on HIVE

Oct 14, 2019 in Big Data Hadoop by Ozer
 • 130 points • 4,208 views
+1 vote
2 answers

How to find the database daily refresh time / sync up time

Sep 17, 2019 in Big Data Hadoop by Hemanth
 • 250 points • 8,857 views
+1 vote
1 answer

sql exception when exporting

Sep 4, 2019 in Big Data Hadoop by Hemanth
 • 250 points • 2,350 views
0 votes
0 answers

HIve query data dates issue

Aug 22, 2019 in Big Data Hadoop by anonymous
 • 867 views
0 votes
1 answer

Error: Hive show tables does not display table "sqooptest" , which was imported by SQOOP

Aug 7, 2019 in Big Data Hadoop by Sheena
 • 1,219 views
0 votes
1 answer

Error: ERROR security.UserGroupInformation: PriviledgedActionException as:root (auth:SIMPLE)

Aug 7, 2019 in Big Data Hadoop by Nashima
 • 1,461 views
0 votes
0 answers

ava.sql.SQLException: Error while processing statement:

Aug 7, 2019 in Big Data Hadoop by Hemanth
 • 250 points • 1,835 views
0 votes
1 answer

Unable to create table in Hive

Aug 6, 2019 in Big Data Hadoop by Tina
 • 636 views
0 votes
1 answer

Hive: org.apache.hadoop.security.AccessControlException Permission denied: user

Aug 1, 2019 in Big Data Hadoop by Ritu
 • 2,804 views
0 votes
1 answer

Spark + Hive connectivity

Aug 1, 2019 in Apache Spark by Jill
 • 1,937 views
0 votes
1 answer

How to select particular column In a table in hive?

Jul 31, 2019 in Big Data Hadoop by Sejal
 • 9,612 views
0 votes
1 answer

Hive: Assign subquery to variable

Jul 30, 2019 in Big Data Hadoop by Kishan
 • 7,069 views
0 votes
1 answer

Converting CSV files to Parquet

Jul 30, 2019 in Big Data Hadoop by Shri
 • 6,895 views
0 votes
1 answer

java.lang.IllegalArgumentException: Unable to instantiate SparkSession with Hive support because Hive classes are not found.

Jul 30, 2019 in Big Data Hadoop by Will
 • 7,346 views
0 votes
1 answer

What is "java.sql.SQLException: org.apache.thrift.transport.TTransportException" in Hive?

Jul 30, 2019 in Big Data Hadoop by nitinrawat895
 • 11,380 points • 6,595 views
0 votes
1 answer

Error while Loading data to Hive.

Jul 29, 2019 in Big Data Hadoop by Will
 • 940 views
0 votes
1 answer

ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: Cannot run program "hive": error=2, No such file or directory

Jul 29, 2019 in Big Data Hadoop by Rasheed
 • 1,760 views
0 votes
1 answer

Does HQL query go to all the nodes to process data?

Jul 26, 2019 in Big Data Hadoop by Tina
 • 500 views
0 votes
1 answer

Why is Hive called as Data Warehouse?

Jul 26, 2019 in Big Data Hadoop by Will
 • 5,768 views
0 votes
2 answers

How to pass external date parameter in hive hql

Jul 26, 2019 by anonymous
 • 120 points • 2,621 views
0 votes
1 answer

Spark: Read from Hive, store in HDFS

Jul 26, 2019 in Apache Spark by Kiran
 • 2,487 views
0 votes
1 answer

Write data into hive table in a parquet

Jul 26, 2019 in Big Data Hadoop by Amrita
 • 2,674 views
Page:

Most popular tags

"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.