Stack Overflow
Stack Overflow

Questions tagged [ingres]

Use this tag for Ingres / Actian X questions. The Ingres v11 RDBMS is now known as Actian X and in addition to supporting OLTP, also supports analytic workloads with X100 tables and Vector engine, making it a hybrid OLTP and analytic database.

The Ingres 11 RDBMS is now known as Actian X and in addition to supporting OLTP, also supports analytic workloads with X100 tables and Vector engine, making it a hybrid OLTP and analytic database.

Actian X combines a record breaking analytic engine with rock solid OLTP to enable enterprise applications with both OLTP and analytic features. The X100 component, from Actian’s Vector analytic database, lets you store Ingres and/or external data in X100 tables, which are processed using the specialized X100 engine, allowing faster performance for analytical database tasks. OLTP and analytic workloads can be run together and the queries and access methods you’re already using can also be run against the X100 data.

Ingres v11 / Actian X product documentation is available here.

Ingres / Actian X customer support forum is here.

151 questions
1
vote
0 answers

Hive to Vectorwise using Sqoop

I have Vectorwise 2.0.2 and Sqoop 1.4.1 installed. When I'm trying to use sqoop-export: sudo -u hdfs ./sqoop-export --driver com.ingres.jdbc.IngresDriver --connect jdbc:ingres://172.16.63.157:VW7/amit --username ingres -P -m 1 --table book_call_log…
Amit
  • 1,620
  • 1
  • 15
  • 24
1
vote
2 answers

Ingres error trying to query timestamp without timezone column

I'm trying to write a query on a column that's of the time "Timestamp without timezone" and this is my where clause: and (cv.expire_ts >= 'today' or ifnull(cv.expir_ts, '') = '') I get the following error: Error: 'today' is invalid format or value…
Catfish
  • 18,876
  • 54
  • 209
  • 353
0
votes
2 answers

How to match number of returned rows to number of arguments inside a SELECT-IN

I have the next query: SELECT EMP.NAME FROM EMPLOYEES EMP WHERE EMP.EMPLOYEE_ID IN (1, 2, 1, 1) ORDER BY EMP.EMPLOYEE_ID; This last query returns 2 rows in an Ingres database (if EMPLOYEE_IDs 1 and 2 exist, that is). How would I have to modify…
carlsLobato
  • 11
  • 4
0
votes
1 answer

SSIS Dataflow ODBC-source to Destination (OLEDB/any)

I have to extract few (5) tables (from Ingres DB) using ODBC connection and load the same in OLE-DB (SQL Server). 1). OLE-DB based connection extract 5 tables name. 2). Using Conrol flow (For each loop container), loading variable (i.e.…
khurram
  • 1
  • 1
0
votes
0 answers

Correlated subquery in WHERE clause

Could someone help me with Correlated subquery in WHERE NOT EXISTS clause using below example of exercise, cause I am not sure how to write this subquery and how would this work in INGRES database. Let's say we have pension plan members who set…
Tomo 1897
  • 1
  • 1
0
votes
1 answer

additionals properties of a model in cakephp?

I'm starting to use cakePhp and I would like to know: When I do a query(like with $this->Product->find(...)), I receive an array, right? Then: -If I've some non-db fields with default values that I've to display for each product, how do I do? I saw…
J4N
  • 19,480
  • 39
  • 187
  • 340
0
votes
1 answer

Calculating total time while certain condition is met Ingres Database

I am having trouble figuring out how to calculate the total time while a certain condition is met. For example, Date Speed 25-jan-2021 15:06:06 150.000 25-jan-2021 15:07:06 150.000 25-jan-2021 15:08:07 150.000 25-jan-2021…
YousoYori
  • 1
  • 1
0
votes
1 answer

Php - Ingres, fresh install : How to debug?

I just finished to install Ingres on my server(only the client part, to connect to an existing ingres server), I just added the php_ingres module. Now php recognize my module, so I tried to connect my self to several existing servers, but I always a…
J4N
  • 19,480
  • 39
  • 187
  • 340
0
votes
1 answer

Two COUNT() columns in a SQL query, one for IN/INNER JOIN and one for NOT IN/LEFT JOIN

Is it possible to create a query where you can have two COUNT() columns where one column is for something like IN() and another one for something like NOT IN() and also just by using JOIN? For instance, I have a table tbl_a and tbl_b. In a single…
Daniel Catalan
  • 1
  • 1
0
votes
2 answers

Install ingres extension for PHP on a debian server

I've to work with a ingres database for my php server. I just have one question: I will never connect myself on an ingres server locally, is it still mandatory to install ingres locally to install ingres? I tried to install ingres with PECL: …
J4N
  • 19,480
  • 39
  • 187
  • 340
0
votes
3 answers

Install ingres extension for php on my WAMP server

I've a development computer, which runs under windows. For a project, I've to make a php website which has to connect to an Ingres database server. So I installed wamp, I installed ingres(server and client, on my local machine). I added the library…
J4N
  • 19,480
  • 39
  • 187
  • 340
0
votes
0 answers

Ingres SQL illegal pattern match and illegal escape sequence, unexpected results

I am querying a database that uses Ingres 10.2. I cannot seem to get any of my pattern matching code to work as I expect it to. For example: SELECT TOP 20 * FROM table_name WHERE variable_name IN ('XaKDG', 'XaKDH') returns both XaKDG and XaKDH as…
mintypasta
  • 11
  • 1
0
votes
1 answer

Ingres to SQL Server DB

Don't know if anyone can help but i have been tasked with getting all the information out of an Ingres DB into a SQL Server DB. I have virtually no experience of Ingres apart from fumbling my way through looking at what it does and how it does…
SteveWWH
  • 1
0
votes
1 answer

Report Builder 3.0 using multiple values in parameter not working with IN Statement

I am trying to use a multi value parameter in my query statement rather than using a filter, however when using the IN command it is not using my parameters given. I have used the JOIN Function to join the values and tried adding quotations around…
Larry
  • 3
  • 2
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 3
…
10 11