My Oracle Support Banner

Querying a Hive Table via the Hive CLI or in the HUE WEb UI using a RegexSerde as the Row Format Fails with Execution Error on Oracle Big Data Appliance (Doc ID 1619024.1)

Last updated on OCTOBER 31, 2019

Applies to:

Big Data Appliance Integrated Software - Version 2.2.1 and later
Linux x86-64



NOTE: In the images,examples and document that follow, user details, cluster names, hostnames, directory paths, filenames, etc. represent a fictitious sample (and are used to provide an illustrative example only).  Any similarity to actual persons, or entities, living or dead, is purely coincidental and not intended in any manner.



Querying a Hive table via the Hive CLI or in the HUE WEb UI using a RegexSerde as the row format fails with:

1. From the Hive Cli:

Diagnostic Messages for this Task:
java.lang.RuntimeException: Error in configuring object
        at org.apache.hadoop.util.ReflectionUtils.setJobConf(
        at org.apache.hadoop.util.ReflectionUtils.setConf(
        at org.apache.hadoop.util.ReflectionUtils.newInstance(
        at org.apache.hadoop.mapred.MapTask.runOldMapper(
        at org.apache.hadoop.mapred.Child$
        at Method)
        at org.apache.hadoop.mapred.Child.main(
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja

FAILED: Execution Error, return code 2 from org.apache.hadoop.hive.ql.exec.MapRedTask
MapReduce Jobs Launched:
Job 0: Map: 1  Reduce: 1   HDFS Read: 0 HDFS Write: 0 FAIL
Total MapReduce CPU Time Spent: 0 msec

2. From the Hue UI:

Note that a query like "select * from table <table_name> will work since no MapReduce is triggered.  Selecting specific columns with "select count (*)" for example, triggers the errors as above.

Steps to reproduce the error:

1. For example with a web log, with a snippet that looks like below:

29-JAN-2014 12:14:10 * oracle "GET /twiki/x/y/z/test?=Test.test HTTP/1.1" 200 9
29-JAN-2014 12:14:11 * oracle "GET /twiki/x/y/z/test1?test1&test1 HTTP/1.1" 200 99
29-JAN-2014 12:14:12 * oracle "GET /file1.gif HTTP/1.0" 200 9999
29-JAN-2014 12:14:13 * oracle "GET /file2.gif HTTP/1.0" 200 999

located at: /user/oracle/app_log/app_log

2. Create a Hive table using a RegexSerde as the row format:

b) From Hue "select * from regexserde_table", results in the error as below:



To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.