Help Center > > Developer Guide> Querying External Data> Querying Data on OBS> OBS Query Overview

OBS Query Overview

Updated at: Dec 30, 2020 GMT+08:00

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.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel