Advertisement
Guest User

clickhouse-arp.yaml

a guest
Mar 18th, 2020
213
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. metadata:
  2.  # Manually Configured Metadata Section.
  3.   name: CLICKHOUSE
  4.   apiname: clickhouse
  5.   spec_version: '1'
  6.  
  7. syntax:
  8.  # Manually Configured Syntax Section.
  9.   identifier_quote: '"'
  10.  identifier_length_limit: 128
  11.  allows_boolean_literal: false
  12.  map_boolean_literal_to_bit: false
  13.  supports_catalogs: false
  14.  supports_schemas: true
  15.  
  16. data_types:
  17.  mappings:
  18.  # Manually Configured Data Types Mappings Section.
  19.  - source:
  20.      name: "INTEGER"
  21.    dremio:
  22.      name: "integer"
  23.    required_cast_arguments: "none"
  24.  - source:
  25.      name: "REAL"
  26.    dremio:
  27.      name: "double"
  28.    required_cast_arguments: "none"
  29.  - source:
  30.      name: "VARCHAR"
  31.    dremio:
  32.      name: "varchar"
  33.    required_cast_arguments: "none"
  34.  - source:
  35.      name: "STRING"
  36.    dremio:
  37.      name: "varchar"
  38.    required_cast_arguments: "none"
  39.  - source:
  40.      name: "DATE"
  41.    dremio:
  42.      name: "varchar"
  43.    required_cast_arguments: "none"
  44.  - source:
  45.      name: "DATETIME"
  46.    dremio:
  47.      name: "timestamp"
  48.    required_cast_arguments: "none"
  49.  - source:
  50.      name: "TIMESTAMP"
  51.    dremio:
  52.      name: "timestamp"
  53.    required_cast_arguments: "none"
  54.  
  55. relational_algebra:
  56.  aggregation:
  57.    enable: true
  58.    group_by_ordinal: false
  59.    distinct: true
  60.    count_functions:
  61.      count_star:
  62.        enable: true
  63.      count:
  64.        enable: true
  65.      count_distinct:
  66.        enable: true
  67.    functions:
  68.    - names:
  69.      - "avg"
  70.      signatures:
  71.      - args:
  72.        - "double"
  73.        return: "double"
  74.      - args:
  75.        - "integer"
  76.        return: "double"
  77.    - names:
  78.      - "max"
  79.      - "min"
  80.      signatures:
  81.      - args:
  82.        - "integer"
  83.        return: "integer"
  84.      - args:
  85.        - "double"
  86.        return: "double"
  87.      - args:
  88.        - "varchar"
  89.        return: "varchar"
  90.    - names:
  91.      - "sum"
  92.      signatures:
  93.      - args:
  94.        - "double"
  95.        return: "double"
  96.      - args:
  97.        - "integer"
  98.        return: "bigint"
  99.  
  100.  except:
  101.    enable: false
  102.  project:
  103.    enable: true
  104.  join:
  105.    enable: true
  106.    cross:
  107.      enable: true
  108.    inner:
  109.      enable: true
  110.      inequality: true
  111.    left:
  112.      enable: true
  113.      inequality: true
  114.    right:
  115.      enable: false
  116.      inequality: false
  117.    full:
  118.      enable: false
  119.      inequality: false
  120.  sort:
  121.    enable: true
  122.    order_by:
  123.      enable: true
  124.      default_nulls_ordering: high
  125.    fetch_offset:
  126.      offset_fetch:
  127.        enable: true
  128.        format: 'LIMIT {1} OFFSET {0}'
  129.      offset_only:
  130.        enable: false
  131.      fetch_only:
  132.        enable: true
  133.        format: 'LIMIT {0}'
  134.  union:
  135.    enable: false
  136.  union_all:
  137.    enable: false
  138.  values:
  139.    enable: false
  140.    method: values
  141.  
  142. # Describe the set of function signatures that are internally supported.
  143. expressions:
  144.  subqueries:
  145.    correlated: true
  146.    scalar: true
  147.    in_clause: true
  148.  supports_case: true
  149.  supports_over: false
  150.  operators:
  151.    - names:
  152.      - "="
  153.      - "!="
  154.      - "<>"
  155.      - ">"
  156.      - ">="
  157.      - "<"
  158.      - "<="
  159.      signatures:
  160.      - args:
  161.        - "double"
  162.        - "double"
  163.        return: "boolean"
  164.      - args:
  165.        - "double"
  166.        - "integer"
  167.        return: "boolean"
  168.      - args:
  169.        - "double"
  170.        - "varchar"
  171.        return: "boolean"
  172.      - args:
  173.        - "integer"
  174.        - "double"
  175.        return: "boolean"
  176.      - args:
  177.        - "integer"
  178.        - "integer"
  179.        return: "boolean"
  180.      - args:
  181.        - "integer"
  182.        - "varchar"
  183.        return: "boolean"
  184.      - args:
  185.        - "varchar"
  186.        - "varchar"
  187.        return: "boolean"
  188.    - names:
  189.      - "not"
  190.      signatures:
  191.      - args:
  192.        - "boolean"
  193.        return: "boolean"
  194.    # Example scalar function
  195.    - names:
  196.      - "sign"
  197.      signatures:
  198.      - args:
  199.        - "double"
  200.        return: "double"
  201.      - args:
  202.        - "integer"
  203.        return: "integer"
  204.        # Example rewrite (although this is not necessary here as the default is the same)
  205.        rewrite: "SIGN({0})"
  206.  
  207.  variable_length_operators:
  208.    - names:
  209.        - and
  210.      variable_signatures:
  211.        - return: boolean
  212.          arg_type: boolean
  213.    - names:
  214.        - or
  215.      variable_signatures:
  216.        - return: boolean
  217.          arg_type: boolean
Advertisement
RAW Paste Data Copied
Advertisement