Help Center> Data Warehouse Service> Developer Guide> Querying External Data> Querying Data on OBS> OBS Query Overview
OBS Query Overview
GaussDB(DWS) provides the SQL on OBS feature that allows users to directly use SELECT to query TEXT, CSV, ORC, or CARBONDATA 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.
When querying OBS data through a foreign table, transaction tables in the CARBONDATA format generated by DLI are not supported. If the table is not a transaction table, you can query it through an OBS foreign table.
Parent topic: Querying Data on OBS
Last Article: Querying Data on OBS
Next Article: Preparing Data on OBS
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.