Stack Overflow
Stack Overflow

Questions tagged [vectorwise]

Use this tag to identify questions that relate to Vectorwise (now known as Actian Vector). Actian Vector is a columnar in-memory analytic database.

Vectorwise is an analytical relational database leveraging the vector pipeline capabilities of modern CPU's. It was developed at the Dutch National Research Institute for Mathematics and Computer Science and was commercialized by Actian Corporation in 2010 and is now known as Actian Vector.

Actian Vector product documentation is available here.

Actian Vector customer support forums are available here.

23 questions
3
votes
3 answers

Dynamic population of SQL in Java from array with nulls

To give a simple example of my problem: //Create database table allowing nulls. CREATE TABLE test(one int not null, two int null, three int not null); Now, in Java I have an array of objects matching the database content. I need to create an…
John Humphreys
  • 37,047
  • 37
  • 155
  • 255
2
votes
2 answers

Alternative ways to write same SQL Query for profiling/testing purposes

I'm testing out an Ingres Vectorwise database to try to find a faster way to run queries as we've been experiencing some slowness with relation to text lookup. Implementation #1 below is very fast if I'm looking up about 5000 items based on a char()…
John Humphreys
  • 37,047
  • 37
  • 155
  • 255
2
votes
2 answers

Select from union of same columns from three tables

I have three tables, A, B, and C. They all hold different data, but have some columns in common. If A, B, and C all have columns C1 and C2 then how can I look up a specific C2 value using a C1 value that could be in any of the 3 tables? Basically,…
John Humphreys
  • 37,047
  • 37
  • 155
  • 255
1
vote
1 answer

Do Ingres and Vectorwise Databases support functionality similar to TRUNCATE table in SQL Server? If so, what is the syntax?

Trying to find if there is something similar to TRUNCATE TABLE in these 2 database systems.
Shiv
  • 11
  • 2
1
vote
1 answer

NULLS LAST flag in Denodo, MemSQL, Spark, VectorWise, and XtremeData

I am doing a pseudo-ORM for a personal project, and I'm compiling a list of compatibility checks for the 20+ different SQL dialects out there. Currently, I am doing research on whether a dialect supports the NULLS LAST flag, i.e. when sorting a…
theGreenCabbage
  • 5,197
  • 19
  • 79
  • 169
1
vote
2 answers

Adding a month to Ansidate

select ansidate(xxx) + '3 months' AS date1 from ( select str_to_date(varchar(max_date),'%Y%m%d') as xxx from comp_stg_rundate where row_key = 1 )as s Max_date is saved as an interger in the comp_stg_rundate table, I want to add 3 months onto this…
user3399863
  • 151
  • 1
  • 1
  • 7
1
vote
2 answers

getting error during describe a table in vectorwise using python ingresdbi module

I am using python ingress module for connectivity with vectorwise database. For describe a table I am using the code below: import ingresdbi local_db = ingresdbi.connect(database ='x',uid ='y',driver ='z',pwd ='p') local_db_cursor =…
rahul sorot
  • 81
  • 1
  • 5
1
vote
1 answer

Porting a query with respect to SQLServer

I have a query in Vectorwise DB as, UPDATE current_load_details cld FROM date_dim dd SET current_date_sk = dd.date_sk ,batchstring = date_part('YEAR', dd.dateval) || CASE WHEN length(date_part('MONTH', dd.dateval)) = 1 THEN '0' ||…
user3357021
  • 11
  • 1
1
vote
2 answers

Repeated insert syntax for efficiency in vectorwise - any examples?

I need to speed up inserts into an Ingress VectorWise database, and the documentation shows this: http://docs.actian.com/ingres-vectorwise/2.5/sql-language-guide/5315-insert The INSERT statement inserts rows into a table. This statement has the…
John Humphreys
  • 37,047
  • 37
  • 155
  • 255
0
votes
1 answer

How to connect VectorWise Database to Azure Data Factory or Azure Synapse?

I have a vectorwise database that contain big size multiple table, I need to copy those table into Azure Storage or Azure SQL DB or Synapse. We don't have direct connector for vectorWise in Azure data factory. Is there any way to connect with…
Asif Khan
  • 143
  • 12
0
votes
1 answer

Convert vectorwise queries into Synapse queries

Is there any third party tool which can convert Vectorwise query into Synapse queries?
ojha
  • 3
  • 3
0
votes
0 answers

Similar functionality as Excel Rate() function in SQL Server

Is there any functionality which work in SQL Server Query similar to as EXCEL Financial RATE() Funtion. Please suggest me any approach as how to receive the same result by SQL Server Query.
user8205502
  • 90
  • 1
  • 9
0
votes
1 answer

How to declare variable in vectorWise like SQL Server?

I am new to VectorWise database. I need to declare variable and pass value in it same like we do in a SQL Server database. Please help me how to do this in VectoreWise database. I am using Squirrel as SQL client. I need to do it like we do in SQL…
user8205502
  • 90
  • 1
  • 9
0
votes
1 answer

How do I load a csv file into actian table?

The "copy" command is successful, but junk data is loaded into the table. "vwload" command errors out with a message "No table name specified". How do I load a csv file into actian table? * COPY TABLE airport2 () FROM '/tmp/head.csv' \g * select *…
shantanuo
  • 31,689
  • 78
  • 245
  • 403
0
votes
1 answer

How to make RANK() or ROW_NUMBER() in ingres/vectorwise ? issue sql code

I am writing a sql query to get sales for different stores on a given day. The query is run against ingres/vectorwise. I want to add a column rank where there is the ranking of the store in regard of sales made in comparaison to all the stores. My…
S.Jackson
  • 129
  • 3
  • 15
1
2