how to slove initialize trafodion question

["Liu, Lei" <le...@esgyn.cn>]

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

RE: how to slove initialize trafodion question

[Selva Govindarajan <se...@esgyn.com>]

Can you please issue

hbcheck

and check if hbase up and running?

You can also invoke hbase shell and scan a small table like TRAFODION._MD_.VERSIONS to check if hbase is up and running.

Selva
-----Original Message-----
From: Liu, Lei [mailto:lei.liu@esgyn.cn] 
Sent: Friday, January 26, 2018 12:06 AM
To: dev@trafodion.apache.org; dev@trafodion.incubator.apache.org
Subject: how to slove initialize trafodion question

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