• Getting Started
  • Vector in Hadoop Concepts
    • Vector in Hadoop Overview
    • Apache Hadoop Overview
      • HDFS and Data Locality
      • YARN
      • Spark
      • NameNodes and DataNodes
    • VectorH and Apache Hadoop Integration
    • Installed Components
  • Recommended Platforms
    • Hadoop Distributions
    • RAID or HDFS File System
    • Supported CPUs
    • Disk Subsystems
    • Connectivity
    • Guidelines for a Balanced Platform
  • Installation Considerations and Requirements
    • Linux Requirements
      • Install Linux Required Software
      • Configure Linux Settings
    • Hadoop Requirement
      • Recommended Hadoop Settings
    • Requirement When Installing VectorH on an HDFS Only Cluster
    • VectorH Cluster Size
    • Java Requirement for Management Server
    • Demo Setup
    • Installation Default Settings
      • Instance ID
      • World Region and Time Zone
        • Time Zone Names
      • Character Set
    • User Names
    • Directory Names
  • Installing VectorH
    • Installation Overview
      • Which DataNodes to Install VectorH On?
    • Set Up the Authorization String
    • How to Install on a Kerberos-enabled Cluster
    • install.sh Command--Install VectorH
      • Examples of Install.sh Command
    • Install VectorH as root (Recommended)
    • Install VectorH as sudo
    • Install VectorH as Non-root
      • Example of Installing with -noroot
    • Install VectorH Using RPM Commands
      • Configure and Start the Instance
    • Set Up Slave Nodes Manually
    • Upgrading VectorH
      • Stop the Instance and Management Server
      • Ways to Upgrade
      • Upgrade Using install.sh (Interactive)
      • Upgrade Using install.sh (Non-interactive)
      • Upgrade User Databases
    • How to Access the Instance on Linux
    • View Installation Environment Settings
  • Installing VectorH Using a Response File
    • Response File--Define Configuration for the Installation
    • Install Vector Using a Response File
    • Example Response File
    • Response File Parameters
      • CONNECT_LIMIT
      • DEFAULT_FS
      • ENABLE_YARN
      • II_AUTH_STRING
      • II_CHECKPOINT
      • II_COMPONENT_CORE
      • II_DATABASE
      • II_DATE_FORMAT
      • II_DBMS_AUTHENTICATION
      • II_DUAL_LOG
      • II_DUMP
      • II_ENABLE_SQL92
      • II_GROUPID
      • II_HDFSBACKUP
      • II_HDFSDATA
      • II_HDFSWORK
      • II_INSTALLATION
      • II_JOURNAL
      • II_LOG_FILE
      • II_LOG_FILE_SIZE_MB
      • II_MONEY_FORMAT
      • II_MTS_JAVA_HOME
      • II_REMOVE_ALL_FILES
      • II_START_ON_BOOT
      • II_SYSTEM
      • II_TERMINAL
      • II_TIMEZONE_NAME
      • II_UPGRADE_USER_DB
      • II_USERID
      • II_VWCFG_BLOCK_SIZE
      • II_VWCFG_BUFFERPOOL
      • II_VWCFG_GROUP_SIZE
      • II_VWCFG_MAX_MEMORY
      • II_VWCFG_MAX_PARALLELISM
      • II_WORK
      • KRB5_KEYTAB_FILE
      • KRB5_KEYTAB_PER_HOST
      • KRB5_PRINCIPAL
      • SILENT_INSTALL
      • SLAVES_LIST
      • YARN_AM_QUEUE
      • YARN_AM_PRIORITY
  • Post-Installation Tasks
    • Configure Linux Settings
    • Enable YARN Integration
      • YARN Resources and VectorH Configuration
        • Understanding YARN Queues
        • How VectorH Configures Resources During Installation
        • Reconfigure YARN Integration
      • Resource Checking at Runtime (x100_server Startup)
        • Restore vectorwise.conf Defaults
  • Starting and Stopping VectorH
    • Start or Shut Down the Vector Instance
      • Start Vector as a Service
  • Uninstalling VectorH
    • How You Safely Uninstall Vector
      • Uninstall VectorH
      • uninstall Command--Uninstall VectorH
  • Connecting to the Installation
    • Network Connections
    • Installing the Client
    • Installing Actian Director
    • Connecting to a Remote Server
    • Connecting Using ODBC
    • Connecting Using JDBC
    • Connecting Using .NET
    • Connecting Through the DAS Server
    • Connecting from Tableau
    • Using the Terminal Monitor (sql)
  • Creating a Database and Loading Data
    • Create a Database
      • Viewing Database Information
    • Connect to or Disconnect from a Database
    • Create a Table
      • VectorH Partitioning Guidelines
        • Changing Partitioning
    • Loading Data
      • Load Data with vwload Utility
      • Load Data with COPY VWLOAD Statement
      • Load Data with Spark SQL through the Spark-Vector Connector
    • Statistics for the Query Optimizer
    • Optimize System Catalogs with sysmod
    • Run a Reporting Query
  • Command Summary
    • Command Summary
    • What Is Next?

Getting Started

Command Summary