建表

見表

CREATE TABLE `external_source`.`algorithm_tag` (
  `tag_code` STRING,
  `category_code` STRING,
  `category_cn` STRING,
  `category_en` STRING,
  `category_dep` STRING,
  `first_level_tag_code` STRING,
  `first_level_tag_cn` STRING,
  `first_level_tag_en` STRING,
  `first_level_tag_dep` STRING,
  `second_level_tag_code` STRING,
  `second_level_tag_cn` STRING,
  `second_level_tag_en` STRING,
  `second_level_tag_dep` STRING,
  `third_level_tag_code` STRING,
  `third_level_tag_cn` STRING,
  `third_level_tag_en` STRING,
  `whether_third_ranking` STRING,
  `global_display_order` STRING)
USING delta
LOCATION 'dbfs:/mnt/for_iqvia/algorithm_output_legacy/tag_dev'