You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Sai Teja Manchi (Jira)" <ji...@apache.org> on 2021/09/17 16:47:00 UTC

[jira] [Created] (HIVE-25537) Last Executed query exit status

Sai Teja Manchi created HIVE-25537:
--------------------------------------

             Summary: Last Executed query exit status
                 Key: HIVE-25537
                 URL: https://issues.apache.org/jira/browse/HIVE-25537
             Project: Hive
          Issue Type: Improvement
            Reporter: Sai Teja Manchi


Is there any way to get status of the Last executed query from beeline?

 

Why is it needed?

We're trying to execute queries from a shell script(input redirection) and want to stop execution if any query fails.

Following is an example:

beeline << EOF

select * from table1;

select * from table2;

EOF

 

In the above case if query 1 fails we want to stop running subsequent queries.

 

Although we can check exit status after closing session in the following way.

beeline << EOF

select * from table1;

EOF

EXIT_STATUS=$?

if[ $EXIT_STATUS -ne 0 ]

then

echo "Failed"

exit $EXIT_STATUS

fi

 

In this case we need to connect to beeline once for each query.

 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)