• Getting Started
•  1. 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
•  2. Recommended Platforms
  • Hadoop Distributions
  • RAID or HDFS File System
  • Supported CPUs
  • Disk Subsystems
  • Connectivity
  • Guidelines for a Balanced Platform
•  3. Installation Considerations and Requirements
  •  Linux Requirements
    • Install Linux Required Software
    • Configure Linux Settings
  •  Hadoop Requirement
    • Recommended Hadoop Settings
    • MapR Requirements
  • 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
•  4. Installing VectorH
  •  Installation Overview
    • Which DataNodes to Install VectorH On?
  • Set Up the Authorization String
  • How to Install on a Kerberos-enabled Cluster
  • How to Install on a MapR Cluster Using Native or Kerberos Security
  •  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
•  5. 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
•  6. 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
•  7. Starting and Stopping VectorH
  •  Start or Shut Down the Vector Instance
    • Start Vector as a Service
•  8. Uninstalling VectorH
  •  How You Safely Uninstall Vector
    • Uninstall VectorH
    • uninstall Command--Uninstall VectorH
•  9. 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)
•  10. 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
•  11. Command Summary
  • Command Summary
  • What Is Next?

Getting Started

11. Command Summary