trafodion-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Selva Govindarajan <selva.govindara...@esgyn.com>
Subject RE: how to slove initialize trafodion question
Date Fri, 26 Jan 2018 17:09:06 GMT
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~!

Mime
View raw message