About
tpcds_query is a local file system connection that points to the directory where the queries of the TPC-DS benchmark.
It's one of the howto's connections created at the installation of Tabulify.
Location
This directory is a subdirectory of the installation directory.
With the connection info command:
tabul connection info tpcds_query
Information about the connection (tpcds_query)
Attribute Value Description
-------------------------- ------------------------------------------- --------------------------------------------------------------------
BOOLEAN_DATA_TYPE Native Boolean data type used to store boolean values
CHAR_DEFAULT_PRECISION 1 Default CHAR precision
COMMENT The location of the Tpc Ds queries A connection description
DATE_DATA_TYPE NATIVE Date data type used to store date values
HOST Host Server
MAX_CONCURRENT_THREAD The maximum number of threads that can be created against the system
MAX_NAME_IN_PATH The maximum number of names in a path
NAME tpcds_query The name of the connection
NATIVES Native Driver attributes (jdbc properties, ...)
NCHAR_DEFAULT_PRECISION 1 Default NCHAR precision
NVARCHAR_DEFAULT_PRECISION 0 Default NVARCHAR precision
ORIGIN The origin of the connection
PASSWORD The user password
PORT Host Port
TABULAR_FILE_TYPE text/csv The default media type when downloading tabular data
TIMESTAMP_DATA_TYPE NATIVE Timestamp data type used to store timestamp values
TIME_DATA_TYPE NATIVE Time format data type to store time values
URI file:///opt/tabulify/resources/tpcds_query/ The uri of the connection
USER The user name
VARCHAR_DEFAULT_PRECISION 0 Default VARCHAR precision
WORKING_PATH /opt/tabulify/resources/tpcds_query The working path (Schema for database, directory for file system)
Directory Structure
With the data list command, we can see that the queries are categorized by database
tabul data list -a count *@tpcds_query
path media_type count
--------- --------------- -----
mysql inode/directory 101
oracle inode/directory 101
postgres inode/directory 102
README.md text/plain 32
sqlite inode/directory 101
sqlserver inode/directory 101