meltano常见问题和处理方式

1
2
3
4
5
6

SELECT a.TABLE_SCHEMA,
a.TABLE_NAME,
a.index_name,
GROUP_CONCAT(column_name ORDER BY seq_in_index) AS `Columns`
FROM information_schema.statistics a WHERE a.index_name='PRIMARY' and a.table_schema=<数据库名称>
GROUP BY a.TABLE_SCHEMA,a.TABLE_NAME,a.index_name

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11

select concat('select ',a.COLUMN_NAME,' from ',a.TABLE_NAME,' where ',a.COLUMN_NAME,' = '''' ; ') from
(
select TABLE_NAME,COLUMN_NAME from information_schema.key_column_usage
where TABLE_SCHEMA = <数据库名称>
and constraint_name='primary') a
inner join
(
select TABLE_NAME,COLUMN_NAME from information_schema.columns
where TABLE_SCHEMA = <数据库名称> and DATA_TYPE in ('varchar')
) b
on a.TABLE_NAME=b.TABLE_NAME and a.COLUMN_NAME = b.COLUMN_NAME;

1
2
3

metadata:
  '*':
    zero_date_time_behavior: convert_to_null