Site LogoSite Logo
  • 🗃️ read_me
  • backend
    • api
    • canal
    • data-systems
    • databases
    • frameworks
    • hologres
      • hologres_
      • hologres_architecture
      • hologres_clustering_key
      • hologres_distribution_key
      • hologres_indexes
      • hologres_qe
      • hologres_segment_key
      • hologres_shard
      • hologres_specific_tables
      • hologres_sql_optimization
      • hologres_storage_engine
      • hologres_storage_modes
      • hologres_table_creation_best_practises
      • hologres_table_group
      • hologres_worker_compute_nodes
    • integration
    • languages
    • media
    • os
    • sql
    • streaming
  • concepts
  • dump
  • finance
  • frontend
  • infrastructure
  • skating
  • backend
  • hologres
  • hologres_storage_modes

🗓️ 03022025 1420

HOLOGRES STORAGE MODES

Syntax​

CREATE TABLE <table_name> (...) WITH (orientation = '[column | row | row,column]');

-- Syntax supported in all Hologres versions:
BEGIN;
CREATE TABLE <table_name> (...);
call set_table_property('<table_name>', 'orientation', '[column | row | row,column]');
COMMIT;

References​

  • https://www.alibabacloud.com/help/en/hologres/user-guide/storage-models-of-tables
Previous
hologres_storage_engine
Next
hologres_table_creation_best_practises
  • Syntax
  • References