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~!
