About ashneesharma88

ashneesharma88 · ‎09-13-2016

HI, I was trying to upgrade the ambari 1.7 from 2.4 and getting error. So I want to know is possible to upgrade the ambari 1.7 to latest version of ambari 2.4.

ashneesharma88 · ‎09-01-2016

Thanks for the reply issue is resolved.

ashneesharma88 · ‎09-01-2016

@Sindhu The issue is with location tables are created in corrrect way. As per the comment of @rguruvannagari issue with SDS table after truncate the table that issue is resolved now getting new error: hive> show create table hive_table; FAILED: SemanticException Unable to fetch table hive_table. null

ashneesharma88 · ‎09-01-2016

I truncate the SDS table now getting null exception. hive> show create table hive_table; FAILED: SemanticException Unable to fetch table hive_table. null

ashneesharma88 · ‎09-01-2016

I have tried this command and the command ran successfully. But still facing same issue:- hive> select * from hive_table; FAILED: SemanticException Unable to fetch table hive_table. java.io.IOException: Incomplete HDFS URI, no host: hdfs://hdptest1:8020:8020/

ashneesharma88 · ‎09-01-2016

I am using HDP 2.4.2-258. I ran the command on hive terminal but getting following error:- hive> show create table hive_table; FAILED: SemanticException Unable to fetch table hive_table. java.io.IOException: Incomplete HDFS URI, no host: hdfs://hdptest:8020:8020/ hive> show create table hive_table; FAILED: SemanticException Unable to fetch table hive_table. java.io.IOException: Incomplete HDFS URI, no host: hdfs://hdptest:8020:8020 Dont know from where this path is taking because I updated the path with following command:- hive --service metatool -updateLocation hdfs://hdptest1:8020 hdfs://localhost:8020 It's urgent. Thanks in advance.

ashneesharma88 · ‎09-01-2016

This issue is resolved after exporting the HIVE home directory:- export HIVE_CONF_DIR=/etc/hive/2.4.2.0-258/0/conf After exporting the directory i got following output Initializing HiveMetaTool.. 16/09/01 06:53:54 INFO metastore.ObjectStore: ObjectStore, initialize called 16/09/01 06:53:54 INFO DataNucleus.Persistence: Property hive.metastore.integral.jdo.pushdown unknown - will be ignored 16/09/01 06:53:54 INFO DataNucleus.Persistence: Property datanucleus.cache.level2 unknown - will be ignored 16/09/01 06:53:55 INFO metastore.ObjectStore: Setting MetaStore object pin classes with hive.metastore.cache.pinobjtypes="Table,Database,Type,FieldSchema,Order" 16/09/01 06:53:56 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as "embedded-only" so does not have its own datastore table. 16/09/01 06:53:56 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as "embedded-only" so does not have its own datastore table. 16/09/01 06:53:56 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MFieldSchema" is tagged as "embedded-only" so does not have its own datastore table. 16/09/01 06:53:56 INFO DataNucleus.Datastore: The class "org.apache.hadoop.hive.metastore.model.MOrder" is tagged as "embedded-only" so does not have its own datastore table. 16/09/01 06:53:56 INFO DataNucleus.Query: Reading in results for query "org.datanucleus.store.rdbms.query.SQLQuery@0" since the connection used is closing 16/09/01 06:53:56 INFO metastore.MetaStoreDirectSql: Using direct SQL, underlying DB is MYSQL 16/09/01 06:53:56 INFO metastore.ObjectStore: Initialized ObjectStore Listing FS Roots.. hdfs://hdptest/db_new.db hdfs://hdptest/db_new1.db hdfs://hdptest/demo_database.db And for second command output is :- /usr/hdp/2.4.2.0-258/hive/bin/schematool -dbType mysql -info WARNING: Use "yarn jar" to launch YARN applications. Metastore connection URL: jdbc:mysql://hdp-test/hive?createDatabaseIfNotExist=true Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: hive Hive distribution version: 1.2.1000 Metastore schema version: 1.2.1000 schemaTool completed

ashneesharma88 · ‎08-31-2016

Hdp version:-HDP 2.4.2.0-258. I am running follwing command :- hive --service metatool -listFSRoot but getting error:- ava.sql.SQLException: Unable to open a test connection to the given database. JDBC url = jdbc:mysql://hdp-test/hive?createDatabaseIfNotExist=true, username = hive. Terminating connection pool (set lazyInit to true if you expect to start your database after your app). Original Exception: ------ java.sql.SQLException: Access denied for user 'hive'@'hdp-test' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529) and also :- /usr/hdp/2.4.2.0-258/hive/bin/schematool -dbType mysql -info WARNING: Use "yarn jar" to launch YARN applications. Metastore connection URL: jdbc:mysql://hdp-test/hive?createDatabaseIfNotExist=true Metastore Connection Driver : com.mysql.jdbc.Driver Metastore connection User: hive org.apache.hadoop.hive.metastore.HiveMetaException: Failed to get schema version. *** schemaTool failed *** Thanks in advance.

ashneesharma88 · ‎08-30-2016

This solution is works for me. Thanks for the immediate reply.

ashneesharma88 · ‎08-29-2016

After enabling HA in hdp 2.4.2.0-258 status is showing active. PFA.

Online	Offline
Last Visited	‎07-18-2024 05:04 PM

Member Since	‎01-04-2016 12:48 PM
Last Visited	‎07-18-2024 05:04 PM
Posts	409
Kudos received	313

Cloudera Community

Re: getting issue from spark-sql.

Re: hive and hbase issue.

Re: Getting erro in hive.

Re: getting error for hadoop command.

Re: Getting error while doing distcp with two secu...

Ambari upgrade .

Re: getting issue after run the command in Hive

Re: getting issue after run the command in Hive

Re: getting issue after run the command in Hive

Re: getting issue after run the command in Hive

getting issue after run the command in Hive

Re: Hive issue.

Hive issue.

Re: Namenode Issue Active and Standby issue in amb...

Namenode Issue Active and Standby issue in ambari ...