ThoughtSpot logo
Software
Cloud ThoughtSpot
Everywhere Seekwell

Software

    • About this release
      • Release notes
      • Fixed issues
      • Downloads
    • Users
      • Introduction
      • Getting started
        • User onboarding experience
        • Finding your way around
        • ThoughtSpot browser access
        • Information Center
        • Your user preferences
        • Use stickers to organize
        • Privileges
          • Understanding privileges
          • Granular access to pinboards
      • Use search
        • What are searches and answers?
        • Search basics
          • Start a new search
          • Choose a data source
          • Search bar features
          • Search suggestions
          • Search results and column types
          • Last data refresh time
          • Work with answers
          • Migrate or restore answers
          • Answer TSL specification
          • Ask an expert
          • Manage Ask an Expert requests
          • Retrieve Ask an Expert answers
          • Answer an expert question
        • Results that are tables
        • Use keywords in search
          • Overview of keyword searches
          • Time series analysis
          • Search using growth over time
          • Using the n keyword for nested searches
          • Proximity search: "near" and "farther than"
        • Work with filters
          • Understand filters
          • Add a filter to a table
          • Add a filter to a chart
          • Create a bulk filter
          • Delete a filter
          • Filter on null, blank, or empty values
        • Other search actions
          • Change result display options
          • Show underlying data
          • See the search behind a result
          • Apply conditional formatting to a table
          • Download your search
          • Replay search
      • Work with charts
        • Chart types
          • Column charts
          • Bar charts
          • Line charts
          • Pie charts
          • Area charts
          • Scatter charts
          • Bubble charts
          • Pareto charts
          • Waterfall charts
          • Treemap charts
          • Line column charts
          • Funnel charts
          • Geo charts
          • Pivot table
          • Sankey charts
          • Radar charts
          • Candlestick charts
        • Changing charts
          • Changing charts
          • Change axes options
          • Configure the columns
          • Rename columns and axes
          • Reorder the labels
          • Set the y-axis range
          • Hide and show values
          • Charts and tables with a very large number of data values
          • Change chart colors
          • Show data labels
          • Show data markers
          • Add regression lines
          • Display gridlines
          • Disable automatic selection of chart type
          • Zoom into a chart
      • Work with formulas
        • Understand formulas
        • Add a formula to search
        • View or edit a formula in a search
        • Aggregate formulas
          • Overview of aggregate formulas
          • Cumulative functions
          • Moving functions
          • Flexible aggregation functions (group aggregate and filters)
          • Grouping functions
          • Filtered aggregation functions
        • Conversion functions
        • Date functions
        • Percent (simple number) calculations
        • Formula operators
        • Nested formulas
        • Formulas for chasm traps
      • Use pinboards
        • Basic pinboard usage
        • Follow a pinboard
        • Edit a pinboard
        • Pinboard filters
        • Answer explorer
        • Schedule a pinboard job
        • Search actions within a pinboard
        • Copy a pinboard
        • Copy a pinboard or visualization link
        • Reset a pinboard or visualization
        • Present a pinboard as a slideshow
        • Download as PDF
        • Migrate or restore pinboards
        • Pinboard TSL specification
      • Use custom R scripts
        • About R in ThoughtSpot
        • Create and share R scripts
        • Run prebuilt R scripts on answers
        • Save and share R visualizations
      • SpotIQ
        • What is SpotIQ
        • Best practices
        • Monitor headlines
        • Comparative analysis
        • Custom SpotIQ analysis
        • Advanced R customizations
        • Insight feedback
        • SpotIQ preferences
      • Work with data
        • Understand data sources
        • Create and load CSV files
        • Append data through the UI
        • View a data profile
        • Set your ThoughtSpot locale
        • Share your work
          • About sharing
          • Share a pinboard
          • Share answers
          • Share uploaded data
          • Request object access
          • Revoke access (unshare)
      • Use SearchIQ
        • About SearchIQ
        • Use SearchIQ for natural searches
        • Teach SearchIQ your language
      • More help and support
    • Administration
      • Introduction to administration
      • Sign-in credentials for administration
      • Understand the architecture
        • Architectural components
        • Data caching
        • Authentication frameworks
        • Data and object security
        • Performance considerations
        • In-memory data compression
      • Admin console
        • Overview
        • Managing users
        • Managing groups
        • Local authentication
        • Authentication through SAML
        • Authentication through Active Directory
        • Configure SSL
        • Configure a reverse SSH tunnel
        • Set the relay host for SMTP (email)
        • Customize ThoughtSpot help
        • Customize actions
        • Style customization
        • Configure NAS for backup storage
        • Manage and create snapshots
        • System overview pinboard
        • System cluster pinboard
        • System alerts pinboard
        • Available cluster updates
      • Installation and setup
        • About installation and upgrades
        • Set your locale
        • Test connectivity between nodes
        • ThoughtSpot use agreement
        • Allow users to request access
        • Set the relay host for SMTP
        • Set up custom calendars
        • Configure internal authentication
        • Configure SSL
        • Configure SAML
        • Enable SSH through Active Directory
        • Integrate LDAP
          • About LDAP integration
          • Configure authentication through Active Directory
          • Add the SSL certificate for LDAP
          • Test the LDAP configuration
          • Sync users and groups from LDAP
        • Configure NAS file system
        • Set up monitoring
        • Configure support services
        • Network ports
        • Configure load balancing and proxies
        • Customize ThoughtSpot help
        • Customize look and feel
      • Load and manage data
        • Introduction to data management
        • Configure casing
        • Load CSV files with the UI
        • How to view a data schema
        • Plan the schema
          • About schema planning
          • Data types
          • Constraints
          • Sharding
          • Chasm traps
        • Build the schema
          • Schema building overview
          • Connect with TQL and create a schema
          • Create a schema in SQL
          • Examples of schema creation
          • Upload a SQL script
        • Change the schema
          • How to change a schema
          • Convert column data type
        • Load bulk data
          • Import CSV files with tsload
          • Use a script
          • Use the tsload connector
        • Delete a data source
          • Delete a data source (table)
          • Delete or change a table in TQL
      • Manage users and groups
        • Onboarding users
        • Understand groups and privileges
        • Create, edit, or delete a group
        • Create, edit, or delete a user
        • Allow users to sign up
      • Security
        • Overview of security features
        • System security
          • Tools and processes
          • About third-party software
          • Installing third-party software
        • Data security
          • Data security
          • Share tables and columns
          • Share worksheets
          • Share views
          • Share pinboards
          • Share answers
          • Revoke access (unshare)
          • Security for SpotIQ functions
        • Row level security (RLS)
          • About row level security (RLS)
          • How rule-based RLS works
          • Set rule-based RLS
        • ThoughtSpot Lifecycle
        • Encryption of data in transit
      • System administration
        • Overview of system administration
        • Send logs when reporting problems
        • Set up recording for Replay Search
        • Upgrade a cluster
      • Backup and restore
        • Understand the backup strategies
        • Understand backup/snapshot schedules
        • Work with snapshots
        • Work with backups
          • Understand backup modes
          • Create a manual backup
          • Configure periodic backups
          • About restore operations
      • Improve search with modeling
        • About data modeling
        • Change a table’s data model
        • Edit the system-wide data model
        • Data model settings
          • Overview of the settings
          • Set column name, description, and type
          • Set additive and aggregate values
          • Hide a column or define a synonym
          • Set columns to exclude from SpotIQ analyses
          • Manage suggestion indexing
          • Add a geographical data setting
          • Set number, date, currency formats
          • Change the attribution dimension setting
          • Add or manage experts
        • Link tables using relationships
          • Link tables using relationships
          • Create a relationship
          • Delete a relationship
          • Use stickers
      • Worksheets: improve search
        • Create and use worksheets
        • Edit a worksheet
        • Create a formula in a worksheet
        • Create worksheet filters
        • How the worksheet join rule works
        • Change join rule or RLS for a worksheet
        • Create a join relationship
        • Modify joins between worksheet tables
        • Delete worksheets or tables
        • Migrate or restore worksheets
        • Worksheet TSL specification
      • Work with views
        • Understand views
        • Save a search as a view
        • Create a search from a view
        • View example scenarios
        • About materialized views
        • Materialize a view
        • Dematerialize a view
        • Refresh a view
        • Schedule view refreshes
      • Scriptability
        • Overview
        • Migrate or restore worksheets
        • Worksheet TSL specification
        • Migrate or restore pinboards
        • Pinboard TSL specification
        • Migrate or restore answers
        • Answer TSL specification
        • SpotApps
      • Set up SearchIQ
        • Enable SearchIQ
        • Optimize SearchIQ
        • SearchIQ optimization steps
          • Enabling columns in SearchIQ
          • Add experts for SearchIQ
          • Train SearchIQ
        • Set entity categories for SearchIQ
        • Change SearchIQ mappings
      • Managed scheduled jobs
        • Job management (scheduled pinboards)
        • Scheduled pinboards management
      • Monitoring
        • Introduction to monitoring
        • Overview board
        • Data board
        • Cluster manager board
        • Alerts and events board
        • System worksheets
        • System pinboards
        • Falcon monitoring pinboards
      • Troubleshooting
        • About troubleshooting
        • Get logs
        • Upload logs to ThoughtSpot Support
        • Network connectivity issues
        • Check the timezone
        • Browser untrusted connection error
        • Characters not displaying correctly
        • Clear the browser cache
        • Cannot open a saved answer that contains a formula
        • Data loading too slowly
        • Search results contain too many blanks
    • Mobile
      • Overview
      • Deploy
      • Install and set up
      • FAQ
      • Release notes
    • Embedding
      • Introduction to embedding
      • Log into the Linux shell using SSH
      • Login credentials
      • Use the JavaScript API
      • SAML
        • About SAML
        • Configure SAML
        • Configure CA SiteMinder
        • Configure Active Directory Federated Services
      • REST API
        • About the REST API
        • Calling the REST API
        • REST API pagination
        • Use the data REST API to get data
        • Use the embedded search API
        • Use the data push API
      • Embed ThoughtSpot
        • Understand embedding
        • Embed pinboard or visualization
        • Authentication flow with embed
        • Full application embedding
        • Configure trusted authentication
      • Runtime filters
        • About runtime filters
        • Apply a runtime filter
        • Runtime filter operators
      • Style customization
        • Customize the application style
        • Upload application logos
        • Set chart and table visualization fonts
        • Choose a background color
        • Select chart color palettes
        • Change the footer text
      • API reference
        • Introduction
        • Pinboard data API
        • Metadata API
        • Session API
        • User API
        • Group API
        • Materialization API
        • Search data API
    • Deploy
      • Overview
      • Amazon Linux 2 support
        • Amazon Linux 2 overview
        • Amazon Linux 2 prerequisites
        • ThoughtSpot deployment artifacts for Amazon Linux 2
        • Online Amazon Linux 2 install
        • Offline Amazon Linux 2 install
        • Amazon Linux 2 upgrade
        • Adding new nodes to clusters in Amazon Linux 2
        • Packages installed with Amazon Linux 2
      • RHEL support
        • RHEL overview
        • RHEL prerequisites
        • ThoughtSpot deployment artifacts for RHEL
        • Online RHEL install
        • Offline RHEL install
        • RHEL upgrade
        • Add new nodes to clusters on RHEL
        • Packages installed with RHEL
      • Hardware appliance
        • Hardware appliance overview
        • Deploying on the SMC appliance
          • Deploying on the SMC appliance
          • Prerequisites
          • Hardware requirements
          • Connect the appliance
          • Configure nodes
          • Install cluster
        • Deploying on the Dell appliance
          • Deploying on the Dell appliance
          • Prerequisites
          • Hardware requirements
          • Connect the appliance
          • Configure management settings
          • Configure nodes
          • Install cluster
      • Cloud
        • Cloud overview
        • AWS
          • Configuration options
          • Set up AWS resources for ThoughtSpot
          • Prepare AWS VMs for ThoughtSpot
          • Configure ThoughtSpot nodes in AWS
          • Install ThoughtSpot clusters in AWS
          • Set up high availability
          • Back up and Restore using S3
        • Azure
          • Configuration options
          • Set up ThoughtSpot in Azure
          • Configure ThoughtSpot nodes in Azure
          • Install ThoughtSpot clusters in Azure
        • GCP
          • Configuration options
          • Set up ThoughtSpot in GCP
          • Configure ThoughtSpot nodes in GCP
          • Install ThoughtSpot clusters in GCP
          • Back up and Restore a GCP cluster using GCS
      • VMware
        • Configuration overview
        • Set up ThoughtSpot in VMware
        • Configure ThoughtSpot nodes in VMware
        • Install ThoughtSpot clusters in VMware
      • Network ports
      • Contact support
    • Embrace
      • Overview
      • Snowflake
        • Overview
        • Add a connection
        • Modify a connection
        • Best practices
        • Reference
        • Snowflake Partner Connect
          • Overview
          • Tutorials
      • Amazon Redshift
        • Overview
        • Add a connection
        • Modify a connection
        • Best practices
        • Reference
      • Google BigQuery
        • Overview
        • Add a connection
        • Modify a connection
        • Reference
      • Azure Synapse
        • Overview
        • Add a connection
        • Modify a connection
        • Reference
      • Teradata
        • Overview
        • Add a connection
        • Modify a connection
        • Reference
      • SAP HANA
        • Overview
        • Add a connection
        • Modify a connection
        • Reference
    • Dataflow
      • Overview
      • Key features
      • How DataFlow works
      • DataFlow home page
      • Requirements and guidelines
      • Database connections
        • Supported database connections
        • Amazon Aurora
          • Overview
          • Connect
          • Sync
          • Reference
        • Amazon Redshift
          • Overview
          • Connect
          • Sync
          • Reference
        • Azure Synapse
          • Overview
          • Connect
          • Sync
          • Reference
        • Cassandra
          • Overview
          • Connect
          • Sync
          • Reference
        • Google BigQuery
          • Overview
          • Connect
          • Sync
          • Reference
        • Hive
          • Overview
          • Connect
          • Sync
          • Reference
        • IBM Db2
          • Overview
          • Connect
          • Sync
          • Reference
        • MariaDB
          • Overview
          • Connect
          • Sync
          • Reference
        • MongoDB
          • Overview
          • Connect
          • Sync
          • Reference
        • MySQL
          • Overview
          • Connect
          • Sync
          • Reference
        • Netezza
          • Overview
          • Connect
          • Sync
          • Reference
        • Oracle
          • Overview
          • Connect
          • Sync
          • Reference
        • PostgreSQL
          • Overview
          • Connect
          • Sync
          • Reference
        • Presto
          • Overview
          • Connect
          • Sync
          • Reference
        • SAP Adaptive Server Enterprise
          • Overview
          • Connect
          • Sync
          • Reference
        • SAP HANA
          • Overview
          • Connect
          • Sync
          • Reference
        • SAP SQL Anywhere
          • Overview
          • Connect
          • Sync
          • Reference
        • SQL Server
          • Overview
          • Connect
          • Sync
          • Reference
        • Snowflake
          • Overview
          • Connect
          • Sync
          • Reference
        • Splice Machine
          • Overview
          • Connect
          • Sync
          • Reference
        • Teradata
          • Overview
          • Connect
          • Sync
          • Reference
      • File system connections
        • Supported file system connections
        • Amazon S3
          • Overview
          • Connect
          • Sync
          • Reference
        • Azure Blob Storage
          • Overview
          • Connect
          • Sync
          • Reference
        • Flat Files
          • Overview
          • Connect
          • Sync
          • Reference
        • Google Cloud Storage
          • Overview
          • Connect
          • Sync
          • Reference
        • HDFS
          • Overview
          • Connect
          • Sync
          • Reference
      • Application connections
        • Supported application connections
        • Salesforce
          • Overview
          • Connect
          • Sync
          • Reference
      • Administration
        • Administration overview
        • Manage DataFlow users
        • DataFlow mail setup
    • Data integration
      • Introduction to data integration
      • JDBC and ODBC setup prerequisites
      • ODBC driver client
        • ODBC driver overview
        • ODBC on Windows
          • Install the ODBC driver on Windows
          • Configure multiple connections on Windows
          • Deploy SSL with ODBC on Windows
          • Set up the ODBC Driver for SSIS
        • Install the ODBC Driver on Linux
        • Best practices for using ODBC
      • JDBC driver client
        • JDBC driver overview
        • Use the JDBC driver
      • Set up the JDBC driver for Pentaho
      • Troubleshooting
        • Troubleshooting data integrations
        • Enable ODBC logs
        • Enable JDBC logs
        • Schema not found error with ODBC
        • How to improve throughput
        • ODBC tracing on Windows
      • Reference
        • Supported SQL commands
        • Connection configuration
    • Disaster recovery
      • About disaster recovery
      • Disk failure
      • Node failure
      • HA and resilience
      • Cluster replacement
        • Overview of cluster replacement
        • Mount a NAS file system
        • Configure disaster recovery
    • Reference
      • About this reference
      • Keyword reference
      • TQL reference
      • tsload flag reference
      • tsload connector reference
      • tscli command reference
      • Date and time formats reference
      • Row level security rules reference
      • Formula function reference
      • Alerts code reference
      • User action code reference
      • Stop word reference
      • Geo map reference
      • Glossary
      • Frequently asked questions
      • Deployment reference
        • Cable reference
        • Network ports
        • The nodes.config file
        • Parameters of the nodes.config file
        • Using the tscli cluster create command
        • Parameters of the tscli cluster create command
        • Site survey PDF
      • ThoughtSpot in practice
        • Introduction
        • Reaggregation in practice
        • Pinboard schedule gating conditions in practice
  • Cloud
    • 8.2.0.cl
    • 8.1.0.cl
  • Home
    • master
  • Software
    • 7.2
    • 7.1
    • 7.0
    • 6.3
    • 6.2
    • 6.1
    • 6.0
  • Software
  • Dataflow
  • Database connections
  • Hive
  • Overview
7.2 7.1 7.0 6.3 6.2 6.1 6.0
Was this page helpful?

Give us feedback!
×

Hive connections in DataFlow

DataFlow enables you to connect to the Hive database, to use your data in ThoughtSpot.

  • Add a connection

  • Sync data

  • Reference

Home Page

ThoughtSpot is the Search & AI-driven Analytics platform for the enterprise. Anyone can use search to analyze company data in seconds and get automated insights when you need them.

Product
  • Product
  • SpotIQ
  • Mobile
  • Embedded Analytics
  • Architecture
  • Pricing
Solutions
  • Overview
  • Retail
  • Financial Services
  • Manufacturing
  • Communications
  • Healthcare
  • Embedded Analytics
  • Procurement
  • Government Analytics
Resources
  • Overview
  • Demo Videos
  • Analyst Reports
  • Webinars
  • Case Studies
  • White Papers
  • Datasheets
  • Solution Briefs
About Us
  • Team
  • Customers
  • Atlas Marketplace
  • Partner Directory
  • Events
  • News
  • Careers
  • Blog
  • Legal
Connect
  • Request Demo
  • Community
  • Support
  • Contact Us

(800) 508-7008

Thoughtspot on Twitter Thoughtspot on Facebook Thoughtspot on LinkedIn

(800) 508-7008

Thoughtspot on Twitter Thoughtspot on Facebook Thoughtspot on LinkedIn
©2022 ThoughtSpot Inc.
All Rights Reserved
Terms of Use Privacy Statement Cookie Policy