Redshift: SQL Functions only on Leader Node

Posted by Saran on

SQL Functions supported only on the Leader Node

  - Any query which references catalog tables (PG_ tables) will be run only on Leader Node.
   SQL> select  * from PG_TABLE_DEF;

  - Any queries which does not reference any tables runs only on Leader Node.

  - Functions which are only supported on the Leader Node 
    SQL> select  CURRENT_SCHEMA();

    SQL> select HAS_TABLE_PRIVILEGE('d_ebook_read','select')

   If an SQL Function which is supported only on Leader node references any user defined tables then it will error out with the following error message.
 ERROR:  Specified types or functions (one per INFO message) not supported on Redshift tables
   
     SQL>

Comments

Post a Comment