Use this starrocks-adapter:
envs:
python-3.7.4
dbt-core-1.1.0
starrocks-2.1.4
The following problems occur:
When creating a project (use 'dbt init'), there is no starrocks adapter to choose from
1）install dbt-starrocks(use 'pip install .' )
2）creating a project (use 'dbt init')
3）There is no 'starrocks-adapter' option
sample_profiles.yml format error(Indent error):
`
default:
outputs:
dev:
type: starrocks
host:
port:
username:
password:
database:
target: dev
`
executing 'dbt run', connection error:
`
Database Error
(1064, "Unknown character set: 'latin1'")
`
When testing 'starrocks.dbtspec test_dbt_base: base', the following exceptions occur
Expected only one database in get_catalog
because of exists two 'information_schema'：
1) {database}.information_schema
2) information_schema
Execute RENAME when creating a view, that is, execute the following commands:
create view {{ to_relation }} as {{ results[0]['Create View'].replace(from_relation.table, to_relation.table).split('AS',1)[1] }} drop view if exists {{ from_relation }};
'unknown error' appears. Two SQL statements cannot be executed at the same time
Use this starrocks-adapter: envs: python-3.7.4 dbt-core-1.1.0 starrocks-2.1.4
The following problems occur:
When creating a project (use 'dbt init'), there is no starrocks adapter to choose from 1）install dbt-starrocks(use 'pip install .' ) 2）creating a project (use 'dbt init') 3）There is no 'starrocks-adapter' option
sample_profiles.yml format error(Indent error): ` default: outputs: dev: type: starrocks host:
port:
username:
password:
database:
target: dev
`
executing 'dbt run', connection error: `
When testing 'starrocks.dbtspec test_dbt_base: base', the following exceptions occur
Expected only one database in get_catalogbecause of exists two 'information_schema'： 1) {database}.information_schema 2) information_schemaExecute RENAME when creating a view, that is, execute the following commands:
create view {{ to_relation }} as {{ results[0]['Create View'].replace(from_relation.table, to_relation.table).split('AS',1)[1] }} drop view if exists {{ from_relation }};'unknown error' appears. Two SQL statements cannot be executed at the same time