Stack Overflow
Stack Overflow

Questions tagged [aginity]

88 questions
0
votes
1 answer

Using nzsql commands in aginity

I'm working with Netezza on Aginity workbench on my windows computer. I'm wondering how I can use nzsql commands such as \l to get a list of databases as shows on this site: http://netezzaonline.blogspot.com/2013/10/netezza-cheat-sheets.html near…
tee
  • 1,286
  • 2
  • 19
  • 35
0
votes
0 answers

Aginity Workbench for puredata systems for analytics Identifier error

This process is to create a new table and ingest data into Netezza database. The code was running fine until last week. When I ran with the new data, it started erroring out. I tried with the old data as well. Any thoughts? Thanks in advance for the…
Gowtham.Subramanian
  • 23
  • 4
0
votes
2 answers

How to select non-integers (varchars) that possibly have leading zeros?

I have a table (let's call it MYTABLE) and within MYTABLE I have a column identity_number, but this number is stored as a string (that's the way it is, I can not change this, because I am not the owner of the data). However, sometimes this number…
Fringo
  • 335
  • 1
  • 3
  • 17
0
votes
2 answers

SQL - Most Recent Time Stamp for Each User

I have a table with a user Account,the current status of the account and the Timestampe of any changes made to the status. When i run the following command for 2 specific accounts it brings back every date & time a change has occured but i only need…
P.4001
  • 41
  • 1
  • 6
0
votes
4 answers

Replace Value in Column with Value in Different Column

I have a dataset that looks like this in SQL. Col1 Col2 Col3 A 4 1 B 5 NULL C 6 1 D 7 NULL E 8 NULL How do I add a new column with the values in Col2 with the…
nak5120
  • 4,089
  • 4
  • 35
  • 94
0
votes
2 answers

Is there a way to get Aginity Workbench to write Unix files rather than Windows files (LF only rather than CR\LF)

Is there a way to get Aginity Workbench to write Unix files rather than Windows files (LF only rather than CR\LF)? "My" developers check their code into SVN on Windows, and then we check it out into a development environment, and it's ...…
Petro
  • 776
  • 6
  • 13
0
votes
2 answers

Amazon redshift query aborts automatically after 1 hour

I have around 500GB compressed data in amazon s3. I wanted to load this data to Amazon Redshift. For that, I have created an internal table in AWS Athena and I am trying to load data in the internal table of Amazon Redshift. Loading of this big data…
RohanB
  • 294
  • 2
  • 5
  • 19
0
votes
1 answer

Newbie help - how to connect to AWS Redshift cluster (currently using Aginity)

(I'm afraid I'm probably about to reveal myself as completely unfit for the task at hand!) I'm trying to setup a Redshift cluster and database to help manage data for a class/group project. I have a dc2.large cluster running with either default…
James
  • 673
  • 6
  • 19
0
votes
1 answer

Aginity SQL error message shows wrong character

When I make a query in Aginity with an error in it, it gives a notification like ERROR: '[My SQL here]' error ^ found "INSERT" (at char 2292) expecting `SELECT' or `'('' If I click on the location of that error in my SQL, it's actually at…
user78090
  • 151
  • 6
0
votes
1 answer

Facing error 'NZOLEDB' provider is not registered on this local machine

I am using Aginity 4.8.0.2551(build 6/14/2016) for connecting Netezza server and the Netezza ODBC driver 6.0.2.0 but still i am getting the error when trying to connect data base server from visual studio platform Error message: The 'NZOLEDB'…
Vinoth
  • 11
  • 2
0
votes
4 answers

Unable to delete duplicate data from Netezza table

I am trying to delete duplicate records from netezza table. But few column contain null value so below code is not working. DELETE FROM TABLE_NAME a WHERE ROW_NUMBER() <> ( SELECT MIN( ROW_NUMBER() ) FROM…
Amlan
  • 15
  • 8
0
votes
1 answer

Joining Based on the Max Date <= a Given Date

I've got two tables that look something like this: Table 1: Unit Date A 9/30/17 B 9/30/17 Table 2: Unit Date Metric A 9/30/17 100 A 6/30/17 250 A 5/31/17 150 B 8/15/17 200 B …
Eric J
  • 192
  • 1
  • 2
  • 10
0
votes
0 answers

Not able to connect to Amazon Redshift Cluster from Aginity

I am trying to connect to Redshift cluster ( available ) from Aginity workbench for Redshift. I plugged in all the required credentials which are used in creating the cluster but still I get the below error. Can someone help me with this. Thank…
Teja
  • 13,214
  • 36
  • 93
  • 155
0
votes
1 answer

Aginity Workbench for Redshift - to_timestamp conversion issue

I am facing an issue when using the function to_timestamp() on Aginity Workbench for AWS Redshift. For some reason I don't understand, 2 hours are added to the timestamp i am trying to create. I have been looking for a solution but couldn't find…
Pierre Dudek
  • 252
  • 4
  • 11
0
votes
0 answers

Datagrip simple calculation on the Select Query Result

I recently switch from Aginity for Redshift to Datagrip for accessing my redshift db. I am wondering for Datagrip is it a function to get simple calculations (like count, sum) on certain columns of the select results like the Aginity for Redshift?…
user2741956
  • 145
  • 2
  • 6
1 2 3 4
5
6