Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Getting erro in hive.

Solved Go to solution

Getting erro in hive.

I am using HDP 2.5.

Getting following error while running select * from query with different user. like test user.

Error:- See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details. Aug 28, 2017 7:40:44 AM WARNING: org.apache.parquet.CorruptStatistics: Ignoring statistics because created_by could not be parsed (see PARQUET-251): parquet-mr (build 32c46643845ea8a705c35d4ec8fc654cc8ff816d) org.apache.parquet.VersionParser$VersionParseException: Could not parse created_by: parquet-mr (build 32c46643845ea8a705c35d4ec8fc654cc8ff816d) using format: (.+) version ((.*) )?\(build ?(.*)\)

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Getting erro in hive.

Issue was with permission of folder. I have provided appropriate permission to /tmp/ and /apps/hive folder.

9 REPLIES 9

Re: Getting erro in hive.

Mentor

@Ashnee Sharma

The underlying reason for this seems to that this file was written using different version of parquet-hadoop and trying to read with another version.

Look out for the hive version run the below command

# locate parquet-hadoop 

Please upgrade the parquet version being used and retry

Re: Getting erro in hive.

Super Mentor

@Ashnee Sharma

Please check if you have the "parquet-logging.properties" file present inside the "/etc/hive/conf/" directory or not?

If not then please copy that file "parquet-logging.properties" from hive2 conf directory to "/etc/hive/conf/" directory and then try again. That file might be missing there due to : https://issues.apache.org/jira/browse/AMBARI-21265

Re: Getting erro in hive.

@Jay SenSharma

File is there.

@ Geoffrey

version is updated only /usr/hdp/2.5.6.0-40/hive/lib/parquet-hadoop-bundle-1.8.1.jar.

is there any soultion.

Re: Getting erro in hive.

Super Mentor

@Ashnee Sharma

Is that file also available inside the "/etc/hive/conf" as well as inside "/etc/hive/conf/conf.server" ?

Also as we see that it is a WARNING message so we can suppress it as well.

Or else can you please share the complete stackTrace so that we can see the complete trace to find out the APIs involved in this WARN.

Re: Getting erro in hive.

File is there on both path.

Re: Getting erro in hive.

Mentor

@Ashnee Sharma

The writing and reading should use the same version of parquet-hadoop.Use the newer version of parquet-hadoop for writing parquet files Also check the permission on the parquet-0.log.lock

Re: Getting erro in hive.

@Geoffrey Shelton Okot

Could you please help me with link? And I able to run with root and hie user without any error or warning. Getting error while running with different user.

Re: Getting erro in hive.

Mentor

@@Ashnee Sharma

Can you check the value for hive.server2.enable.doAs in Hive-->Configs-->settings and filter hive.server2.enable.doAs

Do you have a Ranger default policy configured for hive user ?

Re: Getting erro in hive.

Issue was with permission of folder. I have provided appropriate permission to /tmp/ and /apps/hive folder.

Don't have an account?
Coming from Hortonworks? Activate your account here