How to get results from hive

[Павел Мезенцев <pa...@mezentsev.org>]

 Hello all!

I have the dataset and I want to check it size using hiveQL.
So I execute hive query in oozie:

    <action name="count_lines">
        <hive xmlns="uri:oozie:hive-action:0.2">
              <job-xml>hive-site.xml</job-xml>
            <script>count_lines.hql</script>
              <param>tbl_name=count_line_test</param>
        </hive>
        <ok to="size_decision"/>
        <error to="kill"/>
    </action>

Where count_lines.hql look like this:

SELECT COUNT(*) FROM ${tbl_name};

But after that I wish to make some decision, based on dataset's lines count:
    <decision name="size_decision">
        <switch>
            <case to="too_small">[PREDICATE]</case>
            ...
            <case to="too_big">[PREDICATE]</case>
            <default to="end"/>
        </switch>
    </decision>

How can I do this?


Best regards,
Mezentsev Pavel