Homepage/Cdw Runtime1.5.3

Search Documentation

▶︎Cloudera
1. Reference Architectures
▶︎Cloudera Public Cloud
▼Cloudera Private Cloud
▶︎Cloudera Manager
1. Cloudera Manager
▶︎Applications
▶︎Legacy
▶︎

Data Services
Getting Started
Cloudera Manager
Management Console
Replication Manager
Data Catalog
Data Engineering
Data Warehouse
CDW Runtime
Machine Learning
Base
Getting Started
Runtime & Cloudera Manager
Upgrade
Storage
Flow Management
Streaming Analytics
CFM Operator
CSA Operator
CSM Operator

«

Filter topics

Data Warehouse Runtime
▶︎Concepts
▶︎Planning
1. ▶︎Planning for Apache Impala
  1. Guidelines for Schema Design
▶︎How To
▶︎Troubleshooting
1. ▶︎Troubleshooting Apache Impala
  1. Troubleshooting Impala
▼Reference

About Hue Query Processor
About using Hue
Accessing and using Hue in Cloudera Data Warehouse
Accessing Hive files in Ozone
Accessing Hive files in Ozone
Accessing Iceberg files in Ozone
Accessing Iceberg tables
ACID Operation
ACID operations in Cloudera Data Warehouse
Activating the Hive web UI
Adding a custom banner in Hue
Adding a HiveServer role
Adding a HiveServer role
Adding a splash screen in Hue
Adding Query Processor admin users and groups
Adjusting Heartbeat TCP Timeout Interval
Administering Hue
Aggregate functions
Aggregating and grouping data
ALTER DATABASE statement
ALTER MATERIALIZED VIEW REBUILD
ALTER MATERIALIZED VIEW REWRITE
Alter table feature
ALTER TABLE statement
ALTER VIEW statement
Analytic functions
Apache Hive 3 ACID transactions
Apache Hive 3 in Cloudera Data Warehouse architectural overview
Apache Hive 3 tables
Apache Hive content roadmap
Apache Hive features in Cloudera Data Warehouse
Apache Hive Materialized View Commands
Apache Hive Metastore Overview
Apache Hive Overview
Apache Hive Performance Tuning
Apache Hive query basics
Apache Iceberg features
Apache Iceberg Overview
Apache Impala Overview
Apache Impala Overview
Apache Impala Reference
Apache Impala SQL Overview
Apache Impala SQL Reference
Apache Tez and Hive LLAP
Apache Tez and Hive LLAP
Application not running message
APPX_MEDIAN function
ARRAY complex type
Authentication using PAM
Authentication using SAML
Authorizing external tables
Automatic Invalidation/Refresh of Metadata
AVG
AVG function
Best practices for Iceberg in CDP
BIGINT data type
Bit functions
Bloom Filtering
BOOLEAN data type
Bucketed tables in Hive
Built-in functions
Caching manifest files
CDW stored procedures
Changing the Hive warehouse location
Changing the page logo in Hue
Changing the table metadata location
CHAR data type
CHAR data type support
Checking query execution
Cleaning up old queries
Client connections to HiveServer
COMMENT statement
Comments
Communication encryption
Compaction observability in Cloudera Manager
Compaction of Data in FULL ACID Transactional Table
Compaction tasks
Comparing Hive and Impala queries in Hue
Comparing tables using ANY/SOME/ALL
Complex types
COMPUTE STATS statement
Concepts Used in FULL ACID v2 Tables
Conditional functions
Configure HMS properties for authorization
Configure Impala Daemon to spill to HDFS
Configure Impala Daemon to spill to Ozone
Configuring access to Hive on YARN
Configuring Apache Hive
Configuring Apache Hive Statistics
Configuring Client Access to Impala
Configuring compaction health monitoring
Configuring compaction using table properties
Configuring Delegation for Clients
Configuring Hive
Configuring HiveServer for ETL using YARN queues
Configuring HiveServer high availability using a load balancer
Configuring HiveServer high availability using ZooKeeper
Configuring Impyla for Impala
Configuring legacy CREATE TABLE behavior
Configuring metastore database properties
Configuring metastore location and HTTP mode
Configuring query audit logs to include caller context
Configuring queue mapping to use the user name from the application tag using Cloudera Manager
Configuring temporary table storage
Configuring the compaction check interval
Configuring the Hive Delegation Token Store
Configuring the HiveServer load balancer
Connecting Hive to BI tools using a JDBC/ODBC driver in Cloudera Data Warehouse
Connecting to a kerberized Impala daemon
Connecting to an Apache Hive endpoint through Apache Knox
Conversion functions
Converting a managed non-transactional table to external
Converting Hive CLI scripts to Beeline
COUNT
COUNT function
CREATE DATABASE statement
CREATE FUNCTION statement
CREATE MATERIALIZED VIEW
Create partitioned table as select feature
CREATE ROLE statement
Create table as select feature
Create table feature
CREATE TABLE statement
Create table … like feature
CREATE VIEW statement
Creating a CRUD transactional table
Creating a default directory for managed tables
Creating a function
Creating a group in Hue
Creating a Hue user in Cloudera Data Warehouse
Creating a SQL policy to query an Iceberg table
Creating a temporary table
Creating an Iceberg partitioned table
Creating an insert-only transactional table
Creating an Ozone-based external table
Creating and using a materialized view
Creating and using a partitioned materialized view
Creating tables in Hue by importing files
Creating the tables and view
Creating, using, and dropping an external table
CUME_DIST
Customizing the Hue web interface
Customizing time zones
Data Cache for Remote Reads
Data compaction
Data Durability Considerations
Data types
Data Warehouse Runtime
Databases
Date and time functions
DATE data type
DDL statements
DECIMAL data type
Delete data feature
DELETE statement
Deleting data from a table
DENSE_RANK
DESCRIBE EXTENDED and DESCRIBE FORMATTED
DESCRIBE statement
Describe table metadata feature
Describing a materialized view
Determining the table type
Disabling automatic compaction
Disabling impersonation (doas)
Disabling the share option in Hue
DISTINCT operator
DML statements
DOUBLE data type
Downloading a JDBC driver from Cloudera Data Warehouse
Downloading debug bundles
DROP DATABASE statement
DROP FUNCTION statement
DROP MATERIALIZED VIEW
DROP ROLE statement
DROP STATS statement
Drop table feature
DROP TABLE statement
DROP VIEW statement
Dropping a materialized view
Editing a storage handler policy to access Iceberg files on the file system
Enable EC Replication
Enable stored procedures in CDW
Enable stored procedures in Hue
Enabling all scheduled queries
Enabling browsing Ozone from Hue
Enabling cache-control HTTP headers when using Hue
Enabling or disabling anonymous usage date collection
Enabling SASL in HiveServer
Enabling scheduled queries
Enabling Spark 3 engine in Hue
Enabling the SQL editor autocompleter
Enabling TLS/SSL for HiveServer
Erasure Coding Overview
Escaping an invalid identifier
Expire snapshots feature
Expiring snapshots
EXPLAIN statement
External table access
External tables based on a non-default schema
Filter HMS results
Finding the list of Hue superusers
FIRST_VALUE
Flexible partitioning
FLOAT data type
Functions
Generating and viewing Apache Hive statistics in Cloudera Data Warehouse
Generating and viewing Apache Hive statistics in Cloudera Data Warehouse
Generating Hive statistics
Generating Hive statistics
Generating surrogate keys
Generating Table and Column Statistics
Getting scheduled query information and monitor the query
Getting the JDBC driver
Getting the ODBC driver
GRANT ROLE statement
GRANT statement
GROUP BY clause
GROUP_CONCAT function
Guidelines for Schema Design
Hadoop File Formats Support
HAVING clause
Hive access authorization
Hive ACID metric properties for compaction observability
Hive authentication
Hive demo data
Hive on Tez configurations
Hive unsupported interfaces and features
HMS table storage
Hue configurations in Cloudera Data Warehouse
Hue Overview
Hue overview
Hue supported browsers
HWC authorization
Iceberg data types
Iceberg introduction
Iceberg table properties
Identifiers
Impala aliases
Impala Authorization
Impala lineage
Impala reserved words
Impala Shell Command Reference
Impala Shell Configuration File
Impala Shell Configuration Options
Impala Shell Tool
Impala SQL and Hive SQL
Impala string functions
Impala tables
Impala with Ozone
Increasing StateStore Timeout
INSERT statement
Insert table data feature
Inserting data into a table
Inserting data into a table
Installing Hive on Tez and adding a HiveServer role
INT data type
Integrating Apache Hive with BI Tools
Introduction to Hive metastore
INVALIDATE METADATA statement
JDBC connection string syntax
JDBC connection string syntax
Joins in Impala SELECT statements
Key Differences between INSERT-ONLY and FULL ACID Tables
LAG
LAST_VALUE
Late Materialization of Columns
Lateral View
LEAD
LIMIT clause
Limitations in browsing Ozone from Hue
Limiting concurrent connections
Literals
Load data inpath feature
LOAD DATA statement
Load or replace partition data feature
Locating Hive tables and changing the location
Making row-level changes on V2 tables only
Managing Apache Hive
Managing Apache Impala
Managing Hue permissions
Managing query rewrites
Managing YARN queue users
MAP complex type
Materialized view feature
Materialized view rebuild feature
Materialized views
Mathematical functions
MAX
MAX function
Merge feature
Merging data in tables
Migrate Hive table to Iceberg feature
Migrating a Hive table to Iceberg
MIN
MIN function
Min/Max Filtering
Miscellaneous functions
Monitoring Apache Impala
Monitoring compaction health in Cloudera Manager
NDV function
NTILE
OFFSET clause
Operators
Optimizer hints
Options to monitor compactions
Options to monitor transaction locks
Options to monitor transactions
ORC file format
ORC vs Parquet formats
ORDER BY clause
OVER
Partition evolution feature
Partition Pruning for Queries
Partition transform feature
Partitioning
Partitions and performance
PERCENT_RANK
Performance Best Practices
Performance Considerations
Performance improvement using partitions
Performance tuning
Periodically rebuilding a materialized view
Planner changes for CPU usage
Planning for Apache Impala
Pluggable authentication modules in HiveServer
Ports Used by Impala
Prerequisites
Purposely using a stale materialized view
Query Join Performance
Query metadata tables feature
Query options
Query results cache
Query scheduling
Query vectorization
Query vectorization properties
Querying correlated data
Querying the information_schema database
RANK
REAL data type
Recommended Hive configurations when using Ozone
Refer to a table using dot notation
REFRESH AUTHORIZATION statement
REFRESH FUNCTIONS statement
REFRESH statement
Removing scratch directories
Repairing partitions manually using MSCK repair
Restricting supported ciphers for Hue
REVOKE ROLE statement
REVOKE statement
ROLE statements
Rollback table feature
ROW_NUMBER
Run stored procedure from Hue
Running a query
Running Commands and SQL Statements in Impala Shell
Running time travel queries
Runtime Filtering
SAML properties
Scalability Considerations
Scaling Limits and Guidelines
Schema evolution feature
Schema inference feature
Schema objects
Searching metadata tags
Securing an endpoint under AutoTLS
Securing Apache Hive
Securing Apache Impala
Securing Hive metastore
Securing HiveServer using LDAP
Securing Hue
Securing Hue from CWE-16
Securing sessions
Select Iceberg data feature
SELECT statement
Selecting an Iceberg table
SET statement
Set up a PostgreSQL database
Set up an Oracle database
Set up MariaDB or MySQL database
Setting the cache timeout
Setting the Idle Query and Idle Session Timeouts
Setting Timeout and Retries for Thrift Connections to Backend Client
Setting Timeouts in Impala
Setting up a CDW client
Setting up a JDBC URL connection override
Setting up JdbcStorageHandler for Postgres
Setting up ODBC connection from a BI tool
Setting up the backend Hive metastore database
Setting up the cost-based optimizer and statistics
Setting up the cost-based optimizer and statistics
Setting up the metastore database
SHOW CURRENT ROLES statement
SHOW MATERIALIZED VIEWS
SHOW ROLE GRANT GROUP statement
SHOW ROLES statement
SHOW statement
Showing materialized views
SHUTDOWN statement
SMALLINT data type
Snapshot management
Specify the JDBC connection string
Specifying domains or pages to which Hue can redirect users
Specifying HTTP request methods
Spooling Query Results
SQL migration to Impala
SQL statements
Starting and Stopping Apache Impala
Starting Apache Hive
Starting compaction manually
Statistics generation and viewing commands in Cloudera Data Warehouse
Statistics generation and viewing commands in Cloudera Data Warehouse
STDDEV, STDDEV_SAMP, STDDEV_POP functions
Stored procedure examples
STRING data type
STRUCT complex type
Subqueries in Impala SELECT statements
Subquery restrictions
SUM
SUM function
Supported non-ASCII and special characters in Hue
Table and Column Statistics
Table migration overview
TABLESAMPLE clause
Terminating Hive queries
Test driving Iceberg from Hive
Test driving Iceberg from Impala
Time travel feature
TIMESTAMP data type
TINYINT data type
Token-based authentication for Cloudera Data Warehouse integrations
Tracking an Apache Hive query in YARN
Tracking Hive on Tez query execution
Transactional table access
Transactions
Transactions
Troubleshooting Apache Impala
Troubleshooting Impala
Truncate table feature
TRUNCATE TABLE statement
Tuning Apache Impala
Tuning the metastore
Understand Query Performance
Understanding CREATE TABLE behavior
Understanding Hue users and groups
Understanding Performance using EXPLAIN Plan
Understanding Performance using Query Profile
Understanding Performance using SUMMARY Report
UNION, INTERSECT, and EXCEPT clauses
Unsupported features and limitations
Update data feature
UPDATE statement
Updating an Iceberg partition
Updating data in a table
UPSERT statement
Use a CTE in a query
USE statement
Use wildcards with SHOW DATABASES
User authentication in Hue
User management in Hue
Using a subquery
Using Apache Hive
Using Apache Iceberg
Using Avro Data Files
Using common table expressions
Using constraints
Using governance-based data discovery
Using Hue
Using JdbcStorageHandler to query RDBMS
Using JdbcStorageHandler to query RDBMS
Using optimizations from a subquery
Using ORC Data Files
Using Parquet Data Files
Using RCFile Data Files
Using SequenceFile Data Files
Using Text Data Files
Using the cursor to return record sets
Using your schema in MariaDB
Using your schema in MS SQL
Using your schema in Oracle
Using your schema in PostgreSQL
UTF-8 Support
VALUES statement
VARCHAR data type
VARIANCE, VARIANCE_SAMP, VARIANCE_POP, VAR_SAMP, VAR_POP functions
Vectorization default
Verify the EC Policies
Verify the Related Query Option
Viewing configurations for a Hive query
Viewing DAG information for a Hive query
Viewing explain plan for a Hive query
Viewing Hive query details
Viewing Hive query history
Viewing Hive query information
Viewing Hive query timeline
Viewing Impala profiles in Hue
Viewing Impala query details
Viewing Impala query history
Viewing Impala query information
Viewing the Impala query execution plan
Viewing the Impala query metrics
Views
WINDOW
WITH clause
Working with Apache Hive Metastore

«

Filter topics

▼SHOW CURRENT ROLES statement
1. Syntax

»

Apache Impala SQL Reference

SHOW CURRENT ROLES statement

The SHOW CURRENT ROLES statement displays the roles assigned to the groups of the requesting user.

Syntax🔗

          SHOW ROLES

Parent topic: Impala SQL statements

© 2010–2023 by Cloudera, Inc. All rights reserved.