This is my first time connecting to Vertica. I have already connected to a MySQL database sucessfully by using RODBC library. I have the database setup in vertica and I installed the windows 64-bi...

We have dataset in Vertica and Tableau is querying the data (4 Billions record) from vertica for dashboard as shown below : All list and graphs are separate worksheets in tableau and using same ...

EDIT: Please point out if others are not seeing this issue, and I am doing something wrong. I am trying to add rows to a table containing single VerticaDayTimeInterval column through the VerticaDa...

I am look for a command in vsql which is equivalent of \g in mysql console, because I need display the result set vertically, looking like this:

Suppose mt table name is Table_1 Structure of the table is something like: EMP_id, Emp_Name, File_Name_Input_Date (columns) I am loading Table_1 from a CSV file. The name of this CSV file is da...

I am currently working in a few projects with MongoDB and Apache Cassandra respectively. I am also using Solr a lot and I am handling "lots" of data with them (approx. 1-2TB). I've heard of G...

I'd like my Rails app to run a raw sql command after it establishes the connection to the DB. In which file does that belong? One of the config/initializers?

I'm adapting a web analysis tool to use Vertica as the DB. I'm having real problems optimizing joins. I tried creating pre-join projections for some of my queries, and while it did make the queries...

I am building a web application using Play! with Vertica database as back-end. The JDBC connection string for Vertica contains the server and database name, but my tables are under a specific schem...

I've read the iODBC documentation regarding the odbc.ini, and the Vertica documentation. I also saw a question with the same error, but can't get the connection string to work as suggested in the p...

What is the point in feeding an Hadoop cluster and using that cluster to feed data into a Vertica/InfoBright datawarehouse ? All thse vendor keep saying "we can connect with Hadoop", but I don't u...

I have some problem with connection to my Vertica. I use PHP and PDO ODBC driver (thrue unixODBC). When I connect to Vertica via isql and select records from table all data are fine encoded - field...

I've created a table on Vertica, and I want to create an index on that table. I can't see how to create an index on Vertica, though. Is it possible? If so, how can I do that?

I'm using the following: DRIVER={Vertica ODBC Driver 4.1}; SERVER=lnxtabdb01.xxxx.com; PORT=5433; DATABASE=vertica; USER=dbadmin; PASSWORD=vertica; OPTION=3; i'm getting this error and I just wa...

I have Vertica installed in an Ubuntu virtual machine and I'd like to have a specific database started during the boot, instead of me having to login, open admintools and start from there. So, is ...

I would like to write a MERGE statement in Vertica database. I know it can't be used directly, and insert/update has to be combined to get the desired effect. The merge sentence looks like this: ...

When using vsql, I would like to see how long a query took to run once it completes. For example when i run: select count(distinct key) from schema.table; I would like to see an output like: 56...

What kind of an architecture is needed to store 100 TB data and query it with aggregation? How many nodes? Disk size per node? What can the best practice be? Every day 240GB will be written but t...

I would like to know how I can get the metadata of an object in a Vertica database; like metadata of a table. Is there any table that stores the metadata of objects (functions, views, tables) in Ve...

There is a table with visits data: uid (INT) | created_at (DATETIME) I want to find how many days in a row a user has visited our app. So for instance: SELECT DISTINCT DATE(created_at) AS d FR...

I have a problem with a big query from ten joined tables. I'm migrating data from a wide fact table (f1) into a star schema. I begin by populating the dimension tables from f1 and then I populate t...

Anyone know of a handy function to search through column_names in Vertica? From the documentation, it seems like \d only queries table_names. I'm looking for something like MySQL's information_sche...

I'm trying to create a validation procedure during a load that checks to make sure data isn't duplicated. Vertica doesn't support this natively: Vertica checks for constraint violations when qu...

Hi I have configured the DSN settings for vertica in Ubuntu 10.10 32 bit version machine. The settings are all fine and I have cross checked them. Here is my odbc.ini file: [VerticaDSN] Descri...