Skip to Main Content
Spotfire Ideas Portal
Status To be Reviewed
Categories data sources
Created by Guest
Created on Sep 21, 2026

new data source "Click House"

click house is a new data source that is not in the source list yet. Click house is very useful when user need huge size of dataset. please create the method for click house connection and feature for click house like 'any join, semi join...'. Thanks

  • Attach files
  • Guest
    Sep 21, 2026

    Below is the list shared by the Idea owner -

    i found some function is available in click house but TDV is not supporting that. 
    below are the list :
    ANY JOIN
    SEMI JOIN
    ANTI JOIN
    ASOF JOIN

    funtion :
    uniq()
    uniqExact()
    topK()
    quantile()
    quantileExact()
    median()
    argMax()
    argMin()
    groupArray()
    groupUniqArray()
    arrayJoin()
    arrayMap()
    arrayFilter()
    multiIf()
    extract()