The Vertica Database Forums

doug_harmon

The Vertica blog recently posted an example.

http://www.vertica.com/2012/11/14/how-t ... nalfilter/

doug_harmon

I don't know of a way to speed up the need to download of all of the records without some type of intermediate caching system (Sharepoint, SSAS). Once the records are downloaded the best way to speed up the Excel analysis for smallish (< 1mm record) data sets is to use PowerPivot.

doug_harmon

I was able to connect SAS to Vertica from a Windows OS. After setting up and testing the ODBC connection I used this syntax to create a SAS library. The tricky part is remembering to include the schema name. LIBNAME <VerticaLibaryName> DATASRC='<ODBCDataSourceName' USER='<UserName>' PASSWORD='<Passw...

doug_harmon

Try this:

Code: Select all

select A.*
from (
select random() as RandomNumber, *
from <TableNameGoesHere>  ) as A
order by RandomNumber
limit 100000;

doug_harmon

Thanks for sharing, that's an elegant solution.

doug_harmon

I needed to create a tally table. Here's how I did it. #!/bin/bash # Create a Tally Table. export SQLFile=/tmp/TallyLoad.sql echo -n "" > $SQLFile export DataFile=/tmp/Tally.dat echo -n "" > $DataFile export i for i in {1..100000} do echo "${i}" >> $DataFile done echo 'DROP TABLE Tally;' >> $SQLFile...

Search found 36 matches

Re: Loading data using XML file

Re: Loading data using XML file

Re: Excel + Vertica without MS SQL server cube

Connecting to Vertica from SAS

Re: Selecting a Random Set of Rows from a Table

Re: Tally Table

Tally Table