After you have installed your driver, you can use the driver to access your data with the Interactive SQL tool. Interactive SQL supports a command line interface that allows you to connect to a data source, execute SQL statements and retrieve results for display on a terminal.

To execute commands with Interactive SQL:

  1. Start the ISQL tool. From a command line, enter the following: 
     java -jar impala.jar --isql
  2. Enter connection properties one at a time by typing property=value, then pressing Enter. For example, to configure the ServerName property: 
    ServerName=myserver
  3. After specifying values for your properties, type connect, then press Enter. If successful, the tool will return a confirmation message.
    Note: If you are unable to connect, you can review the URL by entering the SHOW URL command.
  4. At the ISQL> prompt, issue a SQL command to query or modify the data source; then, press Enter. For example: 
    SELECT * FROM USERS;
    Note: SQL commands must be terminated by a semi-colon.
    Note: In addition to SQL commands, the tool supports a set of proprietary commands. Type Help at the prompt for a list of supported commands and syntax.
    The results of the command are displayed in the terminal.
  5. After you are finished executing queries and commands, you can disconnect from the data source by typing the following; then, pressing Enter: 
    DISCONNECT
  6. To end the session, type exit; then, press ENTER.