HQL Execute
Executes a user-defined HiveQL clause.
Information at a Glance
The HQL clause executed inside this operator does not have any dependency on its preceding or succeeding operator. The connection only ensures its execution sequence within the analytic workflow. The HQL Execute code can invoke any well-formed HQL statement based on Spark SQL, including UDFs. Only queries supported by Spark SQL are supported at this time.
Input
No input is required. Alternatively, a Hive table, Load to Hive operator, or other HQL Execute operators (with Pass Output File = true) can be used as input to HQL Execute.
Configuration
Parameter | Description |
---|---|
Notes | Any notes or helpful information about this operator's parameter settings. When you enter content in the Notes field, a yellow asterisk is displayed on the operator. |
Data Source Name | Choose the Hive data source that this runs on. |
SQL Clause | Define the HQL statement to execute. Only HQL accepted by the
Spark SQL implementation is accepted.
For more information, see Define SQL Statement Dialog Box. Note: Do not change the
alpine_sql_output variable while editing a clause. Doing so disrupts the operator from running.
If you compute an aggregated column (for example, SELECT COUNT(*)), you must give it an alias for the HQL Execute operator to run successfully (for example, SELECT COUNT(*) AS total_count). |
Hive Result Database Name | Choose the database in which to place the results, if any. |
Hive Result Table Name | Choose the table in which to place the results, if any. |
Drop If Exists | |
Pass Output File | Pass the output file. |
Results File Structure | Define the structure of the results file. |