Thank you. On Thu, Sep 14, 2017 at 10:58 AM, Dave Birdsall <[email protected]> wrote:
> 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 > >> > > > > >
