Hi Yingshuai,
They are different. I'd suggest you print all columns out.
Each type description has the following columns:
1 TYPE_NAME String => Type name
2 DATA_TYPE int => SQL data type from java.sql.Types
3 PRECISION int => maximum precision
4 LITERAL_PREFIX String => prefix used to quote
You can specify the catalog/schema in the JDBC connection url or the properties
file.
Refer to
http://trafodion.apache.org/docs/jdbct4ref_guide/index.html#type-4-driver-property-descriptions
In the connection url specify the properties using a semicolon separator as
shown here.
jdbc:t4jdbc://lo
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 expl
Trafodion uses the regular ANSI SQL names for its objects in the form
.s.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"
Within interval, there are subtypes as given in cli/sqlcli.h
enum SQLINTERVAL_CODE {
SQLINTCODE_YEAR = 1,
SQLINTCODE_MONTH = 2,
SQLINTCODE_DAY = 3,
SQLINTCODE_HOUR = 4,
SQLINTCODE_MINUTE= 5,
SQLINTCODE_SECOND= 6,
SQLINTCODE_YE
Daily Automated Testing master rh6
Jenkins Job: https://jenkins.esgyn.com/job/Check-Daily-master-rh6/283/
Archived Logs: http://traf-testlogs.esgyn.com/Daily-master/283
Bld Downloads: http://traf-builds.esgyn.com
Changes since previous daily build:
No changes
Test Job Results:
FAILURE phoeni
question:
In Trafodion, is there a default schema or default database called trafodion?
What is the logical relationship between the Trafodion database and the
Trafodion schema?
question:
url=jdbc:t4jdbc://10.10.21.160:23400/, after JDBC uses this URL to connect to
the Trafodion, create a new table, which schema does the table belong to?
question:
In Trafodion, is there a default schema or default database called trafodion?
quersion:
How to specify the database name in the connection URL when using JDBC to
connect Trafodion?
thanks!!!
10 matches
Mail list logo