Which of the following can be achieved using a SELECT statement with Hive or Impala? Check all that apply.
- Displaying the output of an expression
- Loading a file of data into a table
- Listing all the data in a table
- Listing all the tables in a database
- Displaying specific columns in a table
- Displaying the names of the available databases
- Displaying the data in a table using a specific order for the columns