trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Liu, Lei" <lei....@esgyn.cn>
Subject how to slove initialize trafodion question
Date Fri, 26 Jan 2018 08:06:24 GMT
When I initialize trafodion, it not finish
I find it wait when ececute the sql
create view TRAFODION.\"_MD_\".COLUMNS_VIEW as select O.catalog_name, O.schema_name, O.object_name
table_name, C.column_name, C.column_number, cast (case when char_length(trim(sql_data_type))
= 0 then 'UNKNOWN' else sql_data_type end as char(24)) sql_data_type,        C.fs_data_type,
C.column_size, C.column_precision, C.column_scale, C.nullable, C.character_set, C.datetime_start_field,
C.datetime_end_field, case when C.fs_data_type = 192 and C.datetime_start_field = 1 and C.datetime_end_field
= 3 then 1 when C.fs_data_type = 192 and C.datetime_start_field = 1 and C.datetime_end_field
= 6 then 3 when C.fs_data_type = 192 and C.datetime_start_field = 4 and C.datetime_end_field
= 6 then 2 else 0 end dt_code, cast (case when C.fs_data_type = 192 and C.datetime_end_field
= 6 then '(' || trim(cast(C.column_scale as varchar(2))) || ')'  else ' ' end as char(28))
datetime_qualifier, C.default_value  from TRAFODION.\"_MD_\".\"OBJECTS\" O, TRAFODION.\"_MD_\".\"COLUMNS\"
C where O.catalog_name = 'TRAFODION' and O.schema_name != '_MD_' and O.object_uid = C.object_uid
and O.object_type = 'BT' for read uncommitted access order by 1,2,3,4 ;

can you tell me the reason

thanks~!

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message