One thing to add to Selva's response.
During 'initialize trafodion', the default schema 'SEABASE' is automatically
created.
All objects accessed from trafodion ultimately have a 3-part name. These include
trafodion, hive or native HBase objects.
For traf objects, If users don’t specify any explicit schema in their DDL or
DML queries or set a schema
for their session, then the specified objects will be part of SEABASE schema.
for ex: create table t (a int)
will be the same as "create table trafodion.seabase.t (a int)"
or:
select * from t;
will be the same as "select * from trafodion.seabase.t"
When accessing hive or native HBase objects, they also have 3-part name.
hive objects are accessed as: HIVE.<hive-database>.object.
(hive-database is the treated as schema in the 3-part name concept).
native HBase objects are accessed as: HBASE.<row-or-cell-format>.object
Here the first part of the name "HIVE" or "HBASE" is the pseudo 'catalog' name.
anoop
-----Original Message-----
From: Selva Govindarajan [mailto:[email protected]]
Sent: Thursday, December 7, 2017 7:17 AM
To: [email protected]
Subject: RE: rafodion question
Trafodion uses the regular ANSI SQL names for its objects in the form
<Catalog_name>.s<chema_name>.object_name
There is only one catalog called "TRAFODION".
User can create schema via CREATE SCHEMA command. Schema can be considered as
databases.
There is no default schema created as part of installation, though "SEABASE"
will be used as the default schema.
Please refer to SQL Reference manual at
http://trafodion.apache.org/docs/2.1.0/sql_reference/index.html
Selva
-----Original Message-----
From: 韦俊鲁 [mailto:[email protected]]
Sent: Thursday, December 7, 2017 2:12 AM
To: dev <[email protected]>
Subject: rafodion question
question:
In Trafodion, is there a default schema or default database called trafodion?
