Connecting to Vertica Database using SQuirrel SQL Client   Leave a comment

SQuirreL SQL Client is a graphical Java program that will allow you to view the structure of a JDBC compliant database, browse the data in tables, issue SQL commands etc, see Getting Started and Introduction. The minimum version of Java supported is 1.6.x as of SQuirreL version 3.0. See the Old Versions page for versions of SQuirreL that will work with older versions of Java.

In this post I will explain how to use SQuirrel SQL Client to Connect to Vertica Database.

Download the SQuirrel SQL Client by clicking the following link.

http://www.squirrelsql.org/

The SQuirreL SQL Client is installed with the  Java installer. Download the file squirrel-sql-<version>-install.jar and execute it using the following command:

D:\software>java -jar squirrel-sql-3.4.0-install.jar

Now will open the client and configure JDBC to connect to vertica database.Down load jdbc driver from vertica database and rename it from vertica-jdk5-6.0.0-0 to vertica-jdbc5.

Configuring SQuirreL

 

Click on Drivers on the left hand side as shown below.

Click on Create a New Driver:

 

 

 

 

 

Now Click on Aliases on the left side.

 

 

 

 

Thanks

Advertisements

Posted August 25, 2012 by ukatru in vertica

Vertica database Installation steps on two node cluster(Redhat 5.8x86_64)   Leave a comment

Vertica is high-performing, advanced RDBMS that is very simple to install and administer, thanks to the its modern design and purpose built architecture.

Once we execute all preparatory steps on database servers and download Vertica software as per Installation Guide, we are starting installation process on a two node cluster (vertica1, vertica2):

[root@vertica1 tmp]# rpm -ivh vertica-ce-6.0.0-1.x86_64.RHEL5.rpm
Preparing… ########################################### [100%]
1:vertica-ce ########################################### [100%]

Vertica Analytic Database V6.0.0-1 successfully installed on host vertica1.ukatru.com

———————————————————————————-
Important Information
———————————————————————————-
If you are upgrading from a previous version, you must backup your database before
continuing with this install. After restarting your database, you will be unable
to revert to a previous version of the software.
———————————————————————————-

To download the latest Vertica documentation in zip or tar format please visit the
myvertica web site.

o complete installation and configuration of the cluster,
run: /opt/vertica/sbin/install_vertica
[root@vertica1 tmp]# /opt/vertica/sbin/install_vertica -s vertica1.ukatru.com,vertica2.ukatru.com -r vertica-ce-6.0.0-1.x86_64.RHEL5.rpm
Vertica Analytic Database 6.0.0-1 Installation Tool
Starting installation tasks…
Getting system information for cluster (this may take a while)….
Enter password for root@192.168.2.173 (2 attempts left):
Checking/fixing OS parameters…..

Setting vm.min_free_kbytes to 4096 …
Creating/Checking Vertica DBA group

Creating/Checking Vertica DBA user

Installing/Repairing SSH keys for dbadmin

Modifying existing Vertica DBA user

Creating Vertica Data Directory…

Testing N-way network test. (this may take a while)
All hosts are available …
Verifying system requirements on cluster.
IP configuration …
IP configuration …
Testing hosts (1 of 2)….

Running Consistency Tests
LANG and TZ environment variables …
Running Network Connectivity and Throughput Tests…
Waiting for 1 of 2 sites… …

Consistency Test (ok)
=========================

Info: The $TZ environment variable is not set on 192.168.2.172
Info: The $TZ environment variable is not set on 192.168.2.173

Network Test (ok)
=====================

Network communication (ok)
——————————
Low throughput 192.168.2.172 to 192.168.2.173: 88.8967450338 Mbps; check network interface/switch configuration
Low throughput 192.168.2.173 to 192.168.2.172: 87.0492314477 Mbps; check network interface/switch configuration
Updating spread configuration…
Verifying spread configuration on whole cluster.
Creating node node0001 definition for host 192.168.2.172
… Done
Creating node node0002 definition for host 192.168.2.173
… Done
Error Monitor 0 errors 0 warnings
Installation complete.

To create a database:
1. Logout and login as dbadmin.**
2. Run /opt/vertica/bin/adminTools as dbadmin
3. Select Create Database from the Configuration Menu

** The installation modified the group privileges for dbadmin.
If you used sudo to install vertica as dbadmin, you will
need to logout and login again before the privileges are applied.

Documentation:

http://my.vertica.com/docs/CE/6.0.0-1/HTML/index.htm#11927.htm

Posted July 6, 2012 by ukatru in vertica