SAP Knowledge Base Article - Preview

3385665 - Adding physical options to Hive tables should generate ALTER TABLE statement – SAP PD


  • Physical options are added to any table in a Hadoop Hive 2 Physical Data Model (PDM).

  • Hive uses the ALTER TABLE statement to add metadata to tables:
       ALTER TABLE table_name SET TBLPROPERTIES table_properties;
         : (property_name = property_value, property_name = property_value, ... )

  • PD drops then recreates the table, although Hive supports the ALTER TABLE syntax.



  • SAP PowerDesigner (PD) 16.7
  • Hadoop Hive 2


SAP PowerDesigner 16.7


apache, tag, properties, sql, script, 828498, CR828498, CR#828498 , KBA , BC-SYB-PD , PowerDesigner , Known Error

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.