RE: questioin about data type in trafodion

2017-12-07 Thread Xu, Kai-Hua (Kevin)
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

RE: Trafodion question

2017-12-07 Thread Venkat Muthuswamy
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

RE: Trafodion question

2017-12-07 Thread Anoop Sharma
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

RE: rafodion question

2017-12-07 Thread Selva Govindarajan
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"

RE: questioin about data type in trafodion

2017-12-07 Thread Selva Govindarajan
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

Trafodion master rh6 Daily Test Result - 283 - Still Failing

2017-12-07 Thread steve . varnau
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

Trafodion question

2017-12-07 Thread 韦俊鲁
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?

trafodion question

2017-12-07 Thread 韦俊鲁
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?

rafodion question

2017-12-07 Thread 韦俊鲁
question: In Trafodion, is there a default schema or default database called trafodion?

Trafodion question

2017-12-07 Thread 韦俊鲁
quersion: How to specify the database name in the connection URL when using JDBC to connect Trafodion? thanks!!!