Today you cannot create a catalog. There are three "built-in" catalogs.
TRAFODION - contains all Trafodion objects (that is, schemas, tables, indexes, views, sequences, constraints and so on) HBASE - used to denote native HBase objects HIVE - used to denote native Hive objects -----Original Message----- From: Bin Lin [mailto:[email protected]] Sent: Thursday, September 14, 2017 10:53 AM To: [email protected] Subject: Re: create database Another question, can I create a catalog? Thanks. Bin On Wed, Sep 13, 2017 at 10:18 AM, Bin Lin <[email protected]> wrote: > Got it. Thank you. > > On Tue, Sep 12, 2017 at 6:03 PM, Anoop Sharma <[email protected]> > wrote: > >> to add to that. >> >> in Trafodion, a 'database' equivalent is a schema. >> And multiple schemas can be created in a catalog which is >> 'Trafodion'. This is to keep with ansi 3-part naming scheme for every >> object. >> >> One can also do: create schema trafodion.s; or 'get schemas in >> catalog trafodion'. >> >> When you do 'get schemas' or 'show schema' (from trafci), there will >> also be multiple internal system 'schemas' that will show up. >> These schemas (they start and end with an underscore) are reserved >> and not to be used for user objects. >> >> anoop >> >> -----Original Message----- >> From: Liu, Yuan (Yuan) [mailto:[email protected]] >> Sent: Tuesday, September 12, 2017 5:59 PM >> To: [email protected] >> Subject: RE: create database >> >> Please use below syntax, >> >> Create schema test_schema; --create schema Get schemas; --get all >> schemas; Show schema; --show current schema Set schema test_schema; >> --set schema to specific schema >> >> >> Best regards, >> Yuan >> >> -----Original Message----- >> From: Bin Lin [mailto:[email protected]] >> Sent: Wednesday, September 13, 2017 8:53 AM >> To: [email protected] >> Subject: create database >> >> Hi there, >> >> I am trying to create a database in trafci interactive mode. I use >> the command `create database mydatabase`. But it failed. I couldn't >> find examples online about how to create a database and how to check >> all existing databases. >> >> Thank you for your information. >> >> Best, >> Bin >> > >
