﻿/*
 * @Author: huanghe
 * @Date:   2023-02-08 15:32:01
 * @Last Modified by:   huanghe
 * @Last Modified time: 2023-02-08 15:32:23
 */
export const dataset = {
  id: 171,
  name: '测试新增字段默认显示',
  description: '',
  version: 1,
  lastEditVersion: 1,
  realId: 351,
  creator: 'hu.dong@olaola.chat',
  operator: 'hu.dong@olaola.chat',
  docUrl: '',
  workspaceId: 7,
  status: 'ONLINE',
  createTime: '2023-02-01 14:39:06',
  updateTime: '2023-02-01 14:39:06',
  fields: [
    {
      id: 41476,
      name: 'nginx_time',
      fieldExpression: 'nginx_time',
      sourceFieldName: 'nginx_time',
      operation: 'SUM',
      displayName: '接收时间',
      category: 'PROPERTY',
      dataType: 'TIME_YYYYMMDD_HHMMSS',
      originDataType: 'TIME_YYYYMMDD_HHMMSS',
      databaseDataType: 'DateTime',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '接收时间',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 1,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41477,
      name: 'app_version',
      fieldExpression: 'app_version',
      sourceFieldName: 'app_version',
      operation: 'SUM',
      displayName: 'app版本',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: 'app版本',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 2,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41478,
      name: 'position_role',
      fieldExpression: 'position_role',
      sourceFieldName: 'position_role',
      operation: 'SUM',
      displayName: '位置角色',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '位置角色',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 3,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41479,
      name: 'channel',
      fieldExpression: 'channel',
      sourceFieldName: 'channel',
      operation: 'SUM',
      displayName: '渠道',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '渠道',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 4,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41480,
      name: 'game_type',
      fieldExpression: 'game_type',
      sourceFieldName: 'game_type',
      operation: 'SUM',
      displayName: '游戏类型',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '游戏类型',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 5,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41481,
      name: 'type',
      fieldExpression: 'type',
      sourceFieldName: 'type',
      operation: 'SUM',
      displayName: '类型',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '类型',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 6,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41482,
      name: 'mac',
      fieldExpression: 'mac',
      sourceFieldName: 'mac',
      operation: 'SUM',
      displayName: 'mac地址',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: 'mac地址',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 7,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41483,
      name: 'room_types',
      fieldExpression: 'room_types',
      sourceFieldName: 'room_types',
      operation: 'SUM',
      displayName: '房间类型',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 8,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41484,
      name: 'app_id',
      fieldExpression: 'app_id',
      sourceFieldName: 'app_id',
      operation: 'SUM',
      displayName: 'app',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 9,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41485,
      name: 'system_language',
      fieldExpression: 'system_language',
      sourceFieldName: 'system_language',
      operation: 'SUM',
      displayName: '系统语言',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 10,
      createTime: '2023-02-01 14:39:06',
      updateTime: '2023-02-01 14:39:06',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41486,
      name: 'package',
      fieldExpression: 'package',
      sourceFieldName: 'package',
      operation: 'SUM',
      displayName: '包名',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 11,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41487,
      name: 'p_state',
      fieldExpression: 'p_state',
      sourceFieldName: 'p_state',
      operation: 'SUM',
      displayName: '状态',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 12,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41488,
      name: 'os_version',
      fieldExpression: 'os_version',
      sourceFieldName: 'os_version',
      operation: 'SUM',
      displayName: '系统版本',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 13,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41489,
      name: 'room_factory_type',
      fieldExpression: 'room_factory_type',
      sourceFieldName: 'room_factory_type',
      operation: 'SUM',
      displayName: '房间类型',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 14,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41490,
      name: 'v',
      fieldExpression: 'v',
      sourceFieldName: 'v',
      operation: 'SUM',
      displayName: 'v',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 15,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41491,
      name: 'room_property',
      fieldExpression: 'room_property',
      sourceFieldName: 'room_property',
      operation: 'SUM',
      displayName: '房间属性',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 16,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41492,
      name: 'event_name',
      fieldExpression: 'event_name',
      sourceFieldName: 'event_name',
      operation: 'SUM',
      displayName: '时间名称',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 17,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41493,
      name: 'nginx_ip',
      fieldExpression: 'nginx_ip',
      sourceFieldName: 'nginx_ip',
      operation: 'SUM',
      displayName: 'IP',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 18,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41494,
      name: 'did',
      fieldExpression: 'did',
      sourceFieldName: 'did',
      operation: 'SUM',
      displayName: 'did',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 19,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41495,
      name: 'room_type',
      fieldExpression: 'room_type',
      sourceFieldName: 'room_type',
      operation: 'SUM',
      displayName: '房间类型',
      category: 'PROPERTY',
      dataType: 'TEXT',
      originDataType: 'TEXT',
      databaseDataType: 'String',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 20,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41496,
      name: 'kafka_partition',
      fieldExpression: 'kafka_partition',
      sourceFieldName: 'kafka_partition',
      operation: 'SUM',
      displayName: 'Kafka分区',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int32',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: 'Kafka分区',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 22,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41497,
      name: 'dateline',
      fieldExpression: 'dateline',
      sourceFieldName: 'dateline',
      operation: 'SUM',
      displayName: '时间线',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int64',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '时间线',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 23,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41498,
      name: 'is_open_reception',
      fieldExpression: 'is_open_reception',
      sourceFieldName: 'is_open_reception',
      operation: 'SUM',
      displayName: '是否开启服务',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int32',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '是否开启服务',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 24,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41499,
      name: 'onmic_time',
      fieldExpression: 'onmic_time',
      sourceFieldName: 'onmic_time',
      operation: 'SUM',
      displayName: '上麦时长',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int64',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '上麦时长',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 25,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41500,
      name: 'rid',
      fieldExpression: 'rid',
      sourceFieldName: 'rid',
      operation: 'SUM',
      displayName: 'rid',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int64',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: 'rid',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 26,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41501,
      name: 'owner_uid',
      fieldExpression: 'owner_uid',
      sourceFieldName: 'owner_uid',
      operation: 'SUM',
      displayName: '房主ID',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int64',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 27,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41502,
      name: 'kafka_offset',
      fieldExpression: 'kafka_offset',
      sourceFieldName: 'kafka_offset',
      operation: 'SUM',
      displayName: 'kafka偏移量',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int64',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 28,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41503,
      name: 'account_id',
      fieldExpression: 'account_id',
      sourceFieldName: 'account_id',
      operation: 'SUM',
      displayName: '账户id',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int64',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 29,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41504,
      name: 'position_num',
      fieldExpression: 'position_num',
      sourceFieldName: 'position_num',
      operation: 'SUM',
      displayName: '位置',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int32',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 30,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41505,
      name: 'zone_offset',
      fieldExpression: 'zone_offset',
      sourceFieldName: 'zone_offset',
      operation: 'SUM',
      displayName: '时区',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int32',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 31,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41506,
      name: 'event_time',
      fieldExpression: 'event_time',
      sourceFieldName: 'event_time',
      operation: 'SUM',
      displayName: '时间时间',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int64',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 32,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41507,
      name: 'position_id',
      fieldExpression: 'position_id',
      sourceFieldName: 'position_id',
      operation: 'SUM',
      displayName: '位置id',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int32',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 33,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
    {
      id: 41508,
      name: 'is_open_payer',
      fieldExpression: 'is_open_payer',
      sourceFieldName: 'is_open_payer',
      operation: 'SUM',
      displayName: '是否是玩家',
      category: 'INDEX',
      dataType: 'NUMBER',
      originDataType: 'NUMBER',
      databaseDataType: 'Int32',
      dataFormat: 'ORIGINAL',
      customFormatConfig: '{}',
      description: '',
      datasetId: 351,
      hideStatus: 0,
      sortBy: 34,
      createTime: '2023-02-01 14:39:07',
      updateTime: '2023-02-01 14:39:07',
      dataEnable: 1,
      dataFormatCode: 0,
      summaryMethod: 1,
    },
  ],
  datasources: [
    {
      engine: 'CLICKHOUSE',
      db: 'dw_analysis',
      tableName: 'ods_log_bhv_onmic_hi',
      fields: [
        {
          name: 'nginx_time',
          dataType: 'TIME_YYYYMMDD_HHMMSS',
          databaseDataType: 'DateTime',
          description: '接收时间',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'kafka_partition',
          dataType: 'NUMBER',
          databaseDataType: 'Int32',
          description: 'Kafka分区',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'app_version',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: 'app版本',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'dateline',
          dataType: 'NUMBER',
          databaseDataType: 'Int64',
          description: '时间线',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'is_open_reception',
          dataType: 'NUMBER',
          databaseDataType: 'Int32',
          description: '是否开启服务',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'position_role',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '位置角色',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'channel',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '渠道',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'onmic_time',
          dataType: 'NUMBER',
          databaseDataType: 'Int64',
          description: '上麦时长',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'game_type',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '游戏类型',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'type',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '类型',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'rid',
          dataType: 'NUMBER',
          databaseDataType: 'Int64',
          description: 'rid',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'mac',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: 'mac地址',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'room_types',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'owner_uid',
          dataType: 'NUMBER',
          databaseDataType: 'Int64',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'app_id',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'system_language',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'package',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'p_state',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'os_version',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'room_factory_type',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'kafka_offset',
          dataType: 'NUMBER',
          databaseDataType: 'Int64',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'account_id',
          dataType: 'NUMBER',
          databaseDataType: 'Int64',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'v',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'room_property',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'event_name',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'nginx_ip',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'position_num',
          dataType: 'NUMBER',
          databaseDataType: 'Int32',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'zone_offset',
          dataType: 'NUMBER',
          databaseDataType: 'Int32',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'event_time',
          dataType: 'NUMBER',
          databaseDataType: 'Int64',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'did',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'position_id',
          dataType: 'NUMBER',
          databaseDataType: 'Int32',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'room_type',
          dataType: 'TEXT',
          databaseDataType: 'String',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'is_open_payer',
          dataType: 'NUMBER',
          databaseDataType: 'Int32',
          description: '',
          withPermission: true,
          dataEnable: 1,
        },
        {
          name: 'test_001',
          dataType: 'NUMBER',
          databaseDataType: 'Int32',
          description: 'test',
          withPermission: true,
          dataEnable: 1,
        },
      ],
      dataEnable: 0,
    },
  ],
  validDt: '2023-02-07',
  enableApply: 1,
  userResourceRelation: {
    userLevel: 1,
    dataEnable: 1,
    collected: 0,
    applyStatus: 0,
    applying: false,
  },
  dataEnable: 1,
  userLevel: 1,
  collected: 0,
  applyStatus: 0,
}

export const functions = [
  {
    name: 'sum',
    expression: 'sum',
  },
  {
    name: 'max',
    expression: 'max',
  },
  {
    name: 'min',
    expression: 'min',
  },
  {
    name: 'avg',
    expression: 'avg',
  },
  {
    name: 'count',
    expression: 'count',
  },
  {
    name: 'toDateTime',
    expression: 'toDateTime',
  },
  {
    name: 'toDate',
    expression: 'toDate',
  },
  {
    name: 'toMonth',
    expression: 'toMonth',
  },
  {
    name: 'toYear',
    expression: 'toYear',
  },
  {
    name: 'now',
    expression: 'now',
  },
  {
    name: 'substr',
    expression: 'substr',
  },
  {
    name: 'abs',
    expression: 'abs',
  },
  {
    name: 'trim',
    expression: 'trim',
  },
  {
    name: 'length',
    expression: 'length',
  },
  {
    name: 'concat',
    expression: 'concat',
  },
]

export const previewData = {
  status: true,
  data: [],
  fieldNames: [
    '日期，格式为yyyy-mm-dd',
    '礼物名称test12345',
    '礼物类型:enum{普通消费礼物(nor',
    '展示场景类型:set{房间(room),',
    '礼物首次使用时间 yy-mm-dd hh',
    '礼物最近使用时间 yy-mm-dd hh',
    '应用id:1->伴伴,2->皮队友,3-',
    '礼物id',
    '礼物价格，单价：元',
    '礼物价格，单价：分',
    '是否有效:0-上架,1-下架',
    '爵位等级',
    '礼物首次使用时间戳 [在对应应用app内',
    '礼物最近使用时间戳 [在对应应用app内',
    'test123',
    'test123',
    'test123',
    'test4',
    '历史累计总被打赏人数 [在对应应用app',
    '历史累计总打赏次数 [在对应应用app内',
    '历史累计总打赏金额{单位与礼物类型有关:',
    '历史累计房间内总打赏人数 [在对应应用a',
    '历史累计房间内总被打赏人数 [在对应应用',
    '历史累计房间内总打赏次数 [在对应应用a',
    '历史累计房间内总打赏金额{单位与礼物类型',
    '历史累计总打赏人数 [在对应应用app内',
    '历史累计房间外总打赏人数 [在对应应用a',
    '历史累计房间外总被打赏人数 [在对应应用',
    '历史累计房间外总打赏次数 [在对应应用a',
    '历史累计房间外总打赏金额{单位与礼物类型',
    '最近1天总打赏人数 [在对应应用app内',
    '最近1天总被打赏人数 [在对应应用app',
    '最近1天总打赏次数 [在对应应用app内',
    '最近1天总打赏金额{单位与礼物类型有关:',
    '最近1天房间内打赏人数 [在对应应用ap',
    '最近1天房间内被打赏人数 [在对应应用a',
    '最近1天房间内打赏次数 [在对应应用ap',
    '最近1天房间内打赏金额{单位与礼物类型有',
    '最近1天房间外打赏人数 [在对应应用ap',
    '最近1天房间外被打赏人数 [在对应应用a',
    '最近1天房间外打赏次数 [在对应应用ap',
    '最近1天房间外打赏金额{单位与礼物类型有',
    '消耗背包物品总金额，不包含使用背包中优惠券场景，2022-11-30分区生效，2022-12-01日',
    '使用优惠券的减免金额，包含背包中使用优惠券场景，2022-11-30分区生效，2022-12-01日',
    '使用背包消费的礼物的数量，不包含使用背包中优惠券场景，2022-11-30分区生效，2022-12-',
    '使用优惠券消费的礼物数量，2022-11-30分区生效，2022-12-01日生效',
    '最近一天礼物消费数量，2022-11-30分区生效，2022-12-01日生效',
    '最近一天房间内礼物消费数量，2022-11-30分区生效，2022-12-01日生效',
    '最近一天内房间外礼物消费数量，2022-11-30分区生效，2022-12-01日生效',
    '直购消费金额，2022-11-30分区生效，2022-12-02日生效',
    '直购消费数量，2022-11-30分区生效，2022-12-02日生效',
    '直购消费次数，2022-11-30分区生效，2022-12-02日生效',
    '背包消费次数，不包含使用背包中优惠券场景，2022-11-30分区生效，2022-12-02日生效',
    '使用优惠券消费次数，2022-11-30分区生效，2022-12-02日生效',
    '测试字段计算',
    '测试字段计算123',
  ],
  logs: [],
  sql: "select dt as `日期，格式为yyyy-mm-dd`,gift_name as `礼物名称test12345`,gift_type as `礼物类型:enum{普通消费礼物(nor`,display_situation as `展示场景类型:set{房间(room),`,toDateOrNull(first_consume_time) as `礼物首次使用时间 yy-mm-dd hh`,toDateOrNull(last_consume_time) as `礼物最近使用时间 yy-mm-dd hh`,app_id as `应用id:1->伴伴,2->皮队友,3-`,gift_id as `礼物id`,gift_price as `礼物价格，单价：元`,gift_price_point as `礼物价格，单价：分`,is_deleted as `是否有效:0-上架,1-下架`,noble_title_level as `爵位等级`,first_consume_timestamp as `礼物首次使用时间戳 [在对应应用app内`,last_consume_timestamp as `礼物最近使用时间戳 [在对应应用app内`,(display_situation) as `test123`,(display_situation) as `test123`,(display_situation) as `test123`,(gift_name) as `test4`,SUM(consume_dst_user_cnt_da_001) as `历史累计总被打赏人数 [在对应应用app`,SUM(consume_cnt_da_001) as `历史累计总打赏次数 [在对应应用app内`,SUM(consume_amt_da_001) as `历史累计总打赏金额{单位与礼物类型有关:`,SUM(consume_user_cnt_da_002) as `历史累计房间内总打赏人数 [在对应应用a`,SUM(consume_dst_user_cnt_da_002) as `历史累计房间内总被打赏人数 [在对应应用`,SUM(consume_cnt_da_002) as `历史累计房间内总打赏次数 [在对应应用a`,SUM(consume_amt_da_002) as `历史累计房间内总打赏金额{单位与礼物类型`,SUM(consume_user_cnt_da_001) as `历史累计总打赏人数 [在对应应用app内`,SUM(consume_user_cnt_da_003) as `历史累计房间外总打赏人数 [在对应应用a`,SUM(consume_dst_user_cnt_da_003) as `历史累计房间外总被打赏人数 [在对应应用`,SUM(consume_cnt_da_003) as `历史累计房间外总打赏次数 [在对应应用a`,SUM(consume_amt_da_003) as `历史累计房间外总打赏金额{单位与礼物类型`,SUM(consume_user_cnt_1d_001) as `最近1天总打赏人数 [在对应应用app内`,SUM(consume_dst_user_cnt_1d_001) as `最近1天总被打赏人数 [在对应应用app`,SUM(consume_cnt_1d_001) as `最近1天总打赏次数 [在对应应用app内`,SUM(consume_amt_1d_001) as `最近1天总打赏金额{单位与礼物类型有关:`,SUM(consume_user_cnt_1d_006) as `最近1天房间内打赏人数 [在对应应用ap`,SUM(consume_dst_user_cnt_1d_002) as `最近1天房间内被打赏人数 [在对应应用a`,SUM(consume_cnt_1d_028) as `最近1天房间内打赏次数 [在对应应用ap`,SUM(consume_amt_1d_028) as `最近1天房间内打赏金额{单位与礼物类型有`,SUM(consume_user_cnt_1d_007) as `最近1天房间外打赏人数 [在对应应用ap`,SUM(consume_dst_user_cnt_1d_003) as `最近1天房间外被打赏人数 [在对应应用a`,SUM(consume_cnt_1d_029) as `最近1天房间外打赏次数 [在对应应用ap`,SUM(consume_amt_1d_029) as `最近1天房间外打赏金额{单位与礼物类型有`,SUM(consume_amt_1d_034) as `消耗背包物品总金额，不包含使用背包中优惠券场景，2022-11-30分区生效，2022-12-01日`,SUM(discount_amt_1d_002) as `使用优惠券的减免金额，包含背包中使用优惠券场景，2022-11-30分区生效，2022-12-01日`,SUM(consume_num_1d_004) as `使用背包消费的礼物的数量，不包含使用背包中优惠券场景，2022-11-30分区生效，2022-12-`,SUM(consume_num_1d_003) as `使用优惠券消费的礼物数量，2022-11-30分区生效，2022-12-01日生效`,SUM(consume_num_1d_001) as `最近一天礼物消费数量，2022-11-30分区生效，2022-12-01日生效`,SUM(consume_num_1d_005) as `最近一天房间内礼物消费数量，2022-11-30分区生效，2022-12-01日生效`,SUM(consume_num_1d_006) as `最近一天内房间外礼物消费数量，2022-11-30分区生效，2022-12-01日生效`,SUM(consume_amt_1d_036) as `直购消费金额，2022-11-30分区生效，2022-12-02日生效`,SUM(consume_num_1d_002) as `直购消费数量，2022-11-30分区生效，2022-12-02日生效`,SUM(consume_cnt_1d_035) as `直购消费次数，2022-11-30分区生效，2022-12-02日生效`,SUM(consume_cnt_1d_032) as `背包消费次数，不包含使用背包中优惠券场景，2022-11-30分区生效，2022-12-02日生效`,SUM(consume_cnt_1d_031) as `使用优惠券消费次数，2022-11-30分区生效，2022-12-02日生效`,SUM((consume_cnt_1d_001)) as `测试字段计算`,SUM((consume_cnt_1d_001)) as `测试字段计算123` from dws_bban.ads_mkt_gift_app_df_dis where dt = '2023-09-26' group by dt,gift_name,gift_type,display_situation,toDateOrNull(first_consume_time),toDateOrNull(last_consume_time),app_id,gift_id,gift_price,gift_price_point,is_deleted,noble_title_level,first_consume_timestamp,last_consume_timestamp,(display_situation),(display_situation),(display_situation),(gift_name) limit 100",
  elapsed: 0,
  queryId: '9045775-9205936',
  total: 0,
  empty: true,
}
