Tag Info

Hot answers tagged

3

The driver in the connection string needs to be Vertica, not Vertica ODBC Driver 4.1. EXEC dbo.sp_addlinkedserver @server = N'VERTICA', @srvproduct=N'', -- SQL Server driver @provider=N'MSDASQL', -- Connection string @provstr=N'Driver=Vertica; Servername=ServerName; Port=5433; ...


3

You have two options really: You can create a delimited file with your data, like the following: row1col1data,row1col2data,row1col3data,row1col4data row2col1data,row2col2data,row2col3data,row2col4data row3col1data,row3col2data,row3col3data,row3col4data You can then load that into Vertica using the COPY command and vsql. If you have database superuser ...


2

Try to export the data into csv format, and recreate the table in Vertica using the DDL from Oracle. Check the types as they differ from Oracle to Vertica. Example: assuming the following table structure on Oracle: CREATE TABLE PEOPLE ( ID NUMBER (10), NAME VARCHAR2 (50), ADDRESS VARCHAR2 (250), PRIMARY KEY (ID) ) Assuming a compatible ...


1

Vertica only runs on Linux, you can have a Windows client to acesso Vertica. But don't get scared Linux is not such a scary dragon kkkkk. Vertica installs as 1,2,3 check this link for a full installation article. Vertica uses SQL ANSI so no need for you to learn other languages, it has it's differences but is easy to work with. No need for you to break ...


1

From the cross-posted site: Vertica only works on Linux, and only some flavors of Linux are supported officially (can't support everything). Vertica's SQL is based on PostgreSQL. 1 Vertica instance runs over multiple nodes acting in parallel. All of them together constitute the cluster.


1

HP Vertica has their community edition for download at https://my.vertica.com/download-community-edition/. If you don't have one already, you will be prompted to create a MyVertica login. If you have problems creating a login, please email me at dsandahl@vertica.com. If you have further issues loading your data, you can tweet at @VerticaHelp and support will ...



Only top voted, non community-wiki answers of a minimum length are eligible