Community Articles

Find and share helpful community-sourced technical articles.
Celebrating as our community reaches 100,000 members! Thank you!
Labels (1)

Run hive shell debug so it prints detailed error:

hive -hiveconf hive.log.file=hivecli_tez.log -hiveconf hive.log.dir=/tmp/hivecli -hiveconf hive.execution.engine=tez -hiveconf hive.root.logger=DEBUG,DRFA


DEBUG [main]: amazonaws.request ( - Received error response: Forbidden (Service: null; Status Code: 403; Error Code: 403 Forbidden; Request ID: 85BA6566D33A519B), S3 Extended Request ID: 228pqAjcCjTHo+ExpZ+86INHAhkIeE+DQoicPLkan8GDaraxsklIuHwK3f+QmjtIBzw/z5OSWaM= 
WARN [main]: avro.AvroSerDe ( - Encountered AvroSerdeException determining schema. Returning signal schema to indicate problem org.apache.hadoop.hive.serde2.avro.AvroSerdeException: Unable to read schema from given path: s3a://<file-path>


01. mkdir joda-backup

02. cd /tmp

03. wget

04. mv /usr/hdp/current/hive/lib/joda-time-2.5.jar /joda-backup

05. mv /usr/hdp/current/hive2/lib/joda-time-2.5.jar /joda-backup

06. cp /tmp/joda-time-2.8.1.jar /usr/hdp/

07. cp /tmp/joda-time-2.8.1.jar /usr/hdp/

08. unzip joda-time-2.8.1.jar -d /unzip-joda

09. cd ./unzip-joda

Take a backup of hive-exec-*.jar

10. jar -uf /usr/hdp/current/hive/lib/hive-exec-1.2.1000. ./org

11. jar -uf /usr/hdp/current/hive2/lib/hive-exec- ./org

Permissions on this jar should be:

-rw-r--r--. 1 root root joda-time-2.8.1.jar