Select from dual in SQL / Hive
insights Stats
warning Please login first to view stats information.
Raymond
Code Snippets & Tips
Code snippets and tips for various programming languages/frameworks. All code examples are under MIT or Apache 2.0 license unless specified otherwise.
In Oracle database, you can select from dual table if you only want to return a one row result set. In many other databases, the query engine supports select directly from constant values without specifying a table name.
In Hive, there is no system table named Dual. However you can directly created table name Dual.
Alternatively, you can also directly query from constant values or built-in functions without specifying a table name.
Code snippet
CREATE TABLE DUAL(Dummy VARCHAR(1)); INSERT INTO DUAL VALUES ('X'); SELECT CURRENT_DATE from DUAL; SELECT CURRENT_DATE;
info Last modified by Raymond 6 years ago
copyright
This page is subject to Site terms.
comment Comments
No comments yet.