question Re: While accessing hive tables getting cant find schema error in Support Questions

While accessing hive tables getting cant find schema error

er_gurjinder — Thu, 03 Mar 2016 13:33:37 GMT

grunt> A = load 'emp1' Using org.apache.hive.hcatalog.pig.HCatLoader(); 2016-03-04 00:31:02,232 [main] INFO org.apache.hadoop.conf.Configuration.deprecation - fs.default.name is deprecated. Instead, use fs.defaultFS 2016-03-04 00:31:02,411 [main] INFO org.apache.hadoop.hive.metastore.HiveMetaStore - 0: Opening raw store with implemenation class:org.apache.hadoop.hive.metastore.ObjectStore 2016-03-04 00:31:02,413 [main] INFO org.apache.hadoop.hive.metastore.ObjectStore - ObjectStore, initialize called 2016-03-04 00:31:02,417 [main] ERROR org.apache.pig.tools.grunt.Grunt - ERROR 2245: Cannot get schema from loadFunc org.apache.hive.hcatalog.pig.HCatLoader Details at logfile: /usr/lib/hive-0.13.1-bin/hcatalog/pig_1457031005634.log

Re: While accessing hive tables getting cant find schema error

rich1 — Thu, 03 Mar 2016 21:16:42 GMT

@Gurjinder Singh Make sure you have a table in Hive named 'emp1' in the 'default' database.

Re: While accessing hive tables getting cant find schema error

praphul_agarwal — Sun, 10 Jul 2016 18:55:37 GMT

Rich, even if emp1 in default database it would be giving error. I received the same error for below command.

A = Load 'orders_manage1' USING org.apache.hive.hcatalog.pig.HCatLoader();

Re: While accessing hive tables getting cant find schema error

vsithannan — Tue, 26 Jul 2016 23:06:42 GMT

@Praphul Agarwal @Gurjinder Singh - Here are the steps

1) Add the hive connection property in pig properties - PIG_OPTS=-Dhive.metastore.uris=thrift://localhost:10000

2) restart hiveserver, hivemetastore and pig services

3) create a pig script with the load statement 'using org.apache.hive.hcatalog.pig.HCatLoader();'

4) run the pig script - pig -useHCatalog 'pigscript'

Re: While accessing hive tables getting cant find schema error

sanyog_tiwari31 — Tue, 07 Feb 2017 20:48:02 GMT

@vsithannan

"PIG_OPTS=-Dhive.metastore.uris=thrift://localhost:10000 "

This localhost number depends on hive-site.xml or separately we have to defile mine is

<property> <name>hive.metastore.uris</name> <value>thrift://localhost:9083</value> </property>

can you please help me

Re: While accessing hive tables getting cant find schema error

sanyog_tiwari31 — Tue, 07 Feb 2017 20:50:59 GMT

log-file.txt

This my log file while i was trying to get data from hive