Executes a Hive query and returns the results as a data.frame

Executes a Hive query and returns the results as a data.frame

dkuHiveQueryToData(
  database,
  query,
  preQueries = NULL,
  postQueries = NULL,
  connection = NULL,
  findConnectionFromDataset = TRUE
)

Arguments

database

Name of the Hive database to use. This can also be a dataset name. In that case, findConnectionFromDataset must be set to TRUE

query

A Hive query that may or may not return results

preQueries

A list of Hive queries to execute before the main query

postQueries

A list of Hive queries to execute after the main query

connection

Name of a HDFS connection whose Hive database to use. If this parameter is defined, then database has to be NULL

findConnectionFromDataset

Set this to TRUE if the "database" you passed was actually a dataset name

Value

A data.frame with the query results, if any. Else, an empty dataframe

Examples