elementary icon indicating copy to clipboard operation
elementary copied to clipboard

Getting Error in elementary models installation in dbt-spark

Open gargvipul1349 opened this issue 1 year ago • 0 comments

Describe the bug I am getting error in model dbt_metrics while running command dbt --cache-selected-only run --select elementary

 Runtime Error in model dbt_metrics (models/edr/dbt_artifacts/dbt_metrics.sql)
  Database Error
    org.apache.hive.service.cli.HiveSQLException: Error running query: [INTERNAL_ERROR] org.apache.spark.SparkException: [INTERNAL_ERROR] Unexpected table relation: HiveTableRelation [`spark_catalog`.`elementary`.`dbt_metrics`, org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe, Data Cols: [unique_id#1017783, name#1017784, label#1017785, model#1017786, type#1017787, sql#1017788, timest..., Partition Cols: []]

similar error in models -

  • dbt_columns.sql
  • dbt_tests.sql
  • dbt_sources.sql
  • dbt_snapshots.sql
  • dbt_exposures.sql
  • dbt_seeds.sql
  • dbt_models.sql

To Reproduce Steps to reproduce the behavior: dbt --cache-selected-only run --select elementary Screenshot 2024-02-29 at 21 00 11

Screenshots If applicable, add screenshots to help explain your problem.

Environment (please complete the following information):

  • edr Version: [0.14.1]
  • dbt-spark [1.7.0]
  • dbt-core [1.7.0]
  • elementary-data==0.14.1
  • elementary-data[athena]==0.14.1

Additional context dbt_project.yml

models:
  ## see docs: https://docs.elementary-data.com/
  elementary:
    ## elementary models will be created in the schema '<your_schema>_elementary'
    +schema: "elementary"

vars:
  elementary_full_refresh: false

gargvipul1349 avatar Feb 29 '24 15:02 gargvipul1349