Hive table is invisible if the script is scheduled with oozie

AlinaGHERMAN — Fri, 16 Sep 2022 09:17:00 GMT

Hello,

I did a simple script for creating a table, and it works fine in the Hue browser.

CREATE DATABASE IF NOT EXISTS test;
create table test.agh_test_table_creation(
  id                int,
  dtDontQuery       string,
  name              string
)

When I schedule the script with oozie I get successful, but the table is not visible in the hue browser.However, the table is present in the folder: user/hive/warehouse

Note: My oozie workflow contains the hdfs-site.xml location:

<workflow-app name="AGH_TEST_default_workspace_create_table" xmlns="uri:oozie:workflow:0.4">
    <start to="AGH_test_default_create_table_test"/>
    <action name="AGH_test_default_create_table_test">
        <hive xmlns="uri:oozie:hive-action:0.2">
            <job-tracker>${jobTracker}</job-tracker>
            <name-node>${nameNode}</name-node>
              <job-xml>hdfs-site.xml</job-xml>
            <script>tes_table_creation_oozie</script>
            <file>hdfs-site.xml#hdfs-site.xml</file>
        </hive>
        <ok to="end"/>
        <error to="kill"/>
    </action>
    <kill name="kill">
        <message>Action failed, error message[${wf:errorMessage(wf:lastErrorNode())}]</message>
    </kill>
    <end name="end"/>
</workflow-app>

I got the hdfs-site.xml by downloading it from Cloudera Manager-> Clusters-> Hive-> Actions-> Download Client configuration

Also, the source of the issue is not reling in the derby metastore since the metastore database is not the default one. I'm mentioning this, because of the stackoverflow post: http://stackoverflow.com/questions/23615309/oozie-with-hive-issue

What should I do in order to make the table visible in the hue interface?

Thank you !

Re: Hive table is invisible if the script is scheduled with oozie

AlinaGHERMAN — Wed, 31 Dec 2014 08:58:26 GMT

I found my error:

- I included the hdfs-site.xml file (and not hive-site.xml)

- the name of the file has to be changed (if not I have permission denied)

Thank you!

question Hive table is invisible if the script is scheduled with oozie in Support Questions

Hive table is invisible if the script is scheduled with oozie

Re: Hive table is invisible if the script is scheduled with oozie