-
Notifications
You must be signed in to change notification settings - Fork 1
/
prepare.sql
69 lines (63 loc) · 4.24 KB
/
prepare.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
create database compare_tools;
--use compare_tools;
CREATE TABLE compare_tools.inconsistent_record (
id bigint(20) NOT NULL AUTO_INCREMENT,
project text CHARACTER SET utf8 NOT NULL,
query text CHARACTER SET utf8 NOT NULL,
gluten_result mediumtext CHARACTER SET utf8 NOT NULL,
normal_result mediumtext CHARACTER SET utf8 NOT NULL,
tag text CHARACTER SET utf8 NOT NULL,
createtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id)
);
CREATE TABLE compare_tools.response_time (
id bigint(20) NOT NULL AUTO_INCREMENT,
project text CHARACTER SET utf8 NOT NULL,
query text CHARACTER SET utf8 NOT NULL,
gluten_res_time bigint,
normal_res_time bigint,
if_fallback BOOLEAN,
createtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id)
);
CREATE TABLE compare_tools.error_category (
id bigint(20) NOT NULL AUTO_INCREMENT,
keywords text CHARACTER SET utf8 NOT NULL,
tag text CHARACTER SET utf8 NOT NULL,
status text CHARACTER SET utf8 NOT NULL,
createtime timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (id)
);
insert into compare_tools.error_category(keywords,tag,status)
values('SELECT /*+,OBJECT STORAGE Exception', 'comment_analyze', 'unsolved'),
(': Object,not found', 'sql_object_not_found', 'unsolved'),
('s3: //,[OBJECT STORAGE Exception] Input path does not exist', 's3_path_not_found', 'unsolved'),
('[OBJECT STORAGE Exception],com.amazonaws.services.s3.model.AmazonS3Exception: Forbidden (Service: Amazon S3', 's3_access_forbidden', 'unsolved'),
('KE-010001201:,t find project', 'project_not_found', 'unsolved'),
('[OBJECT STORAGE Exception] : Instantiate org.apache.hadoop.fs.s3a.auth.AssumedRoleCredentialProvider,Service: AWSSecurityTokenService,Error Code: AccessDenied', 'aws_access_denied', 'unsolved'),
('[OBJECT STORAGE Exception] Table or view not found', 'table_view_not_found' ,'unsolved'),
('Column,not found in', 'column_not_found' ,'unsolved'),
('Cannot apply,FLOOR,to arguments of type', 'floor_args_error' ,'unsolved'),
('Illegal use of,NULL', 'Illegal_use_of_null' ,'unsolved'),
('The query exceeds the set time limit', 'time_out' ,'unsolved'),
('OBJECT STORAGE Exception,ExecutorLostFailure,Job aborted due to stage failure,Remote RPC client disassociated', 'executor_lost' ,'unsolved'),
('OBJECT STORAGE Exception,ExecutorLostFailure,Job aborted due to stage failure,Executor heartbeat timed out after', 'executor_heartbeat_time_out' ,'unsolved'),
('OBJECT STORAGE Exception,org.apache.hadoop.hive.ql.metadata.HiveException,Unable to get database object', 'metadata_unable_to_get_database_object' ,'unsolved'),
('OBJECT STORAGE Exception,org.apache.hadoop.hive.ql.metadata.HiveException,Unable to fetch table', 'metadata_unable_to_fetch_table' ,'unsolved'),
('KE-010003208: Invalid username or password', 'invalid_username_or_password' ,'unsolved'),
('OBJECT STORAGE Exception,java.lang.InterruptedException', 'object_storage_interrupted_exception' ,'unsolved'),
('[OBJECT STORAGE Exception] initializing on s3', 'object_storage_s3_initializing_exception' ,'unsolved'),
('[OBJECT STORAGE Exception] Instantiate org.apache.hadoop.fs.s3a.auth.AssumedRoleCredentialProvider,Interrupted waiting to refresh the value', 'object_storage_s3_credential_refresh_interrupted' ,'unsolved'),
('KE-010024001,have access', 'user_cannot_access' ,'unsolved'),
('Logic error', 'logic_error' ,'unsolved'),
('Illegal type Date32 of argument for aggregate function sum', 'date32_aggregate_error' ,'unsolved'),
('Cannot create enum from null value', 'create_enum_from_null_value' ,'unsolved'),
('[OBJECT STORAGE Exception] getFileStatus on s3', 'get_s3_file_status_error' ,'unsolved'),
('[OBJECT STORAGE Exception] Instantiate org.apache.hadoop.fs.s3a.auth.AssumedRoleCredentialProvider,com.amazonaws.AbortedException', 's3_access_aborted' ,'unsolved'),
('datasources.v2.text.TextScan', 'textscan_init_no_such_method' ,'unsolved'),
('Bad URI syntax', 'bad_uri_syntax' ,'unsolved'),
('Expected end of line', 'expected_end_of_line' ,'unsolved'),
('Unexpected empty column', 'unexpected_empty_column' ,'unsolved'),
('Cannot parse CSV format', 'csv_parse_error' ,'unsolved'),
('Cannot parse input', 'cannot_parse_input' ,'unsolved'),
('Failed to get object info,No response body', 'no_response_body' ,'unsolved'),