• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Querying External Data
  5. Querying Data on OBS
  6. OBS Query Overview

OBS Query Overview

DWS provides the SQL on OBS feature that allows users to directly use SELECT to query TEXT, CSV, or ORC data stored on OBS through a foreign table, so that they do not need to import OBS data to a data warehouse cluster and query it. In this way, query time and cluster resource consumption are greatly reduced. This chapter describes how to query for ORC data stored in OBS as an example.