Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [redshift]

Redshift : Amazon's Column-Oriented Database Product

First released Feb 15, 2013, Redshift became part of the cloud within Amazon Web Services but is distinguished from Amazon RDS. It can handle JDBC/ODBC connections and allow accessing to a variety of BI Tools such as

  • Oracle BI Suite (Enterprise Edition)
  • Pentaho
  • MicroStrategy
  • Jaspersoft
  • and more

For more info, please read the following:

172 questions
15
votes
3 answers

Redshift table not showing up in tables for schema?

On Redshift, why doesn't my table show up in the following query? It definitely exists, as shown by the next query I run. I want a way to list all tables for a schema: mydb=# select distinct(tablename) from pg_table_def where schemaname = 'db'; …
Some Guy
  • 251
  • 1
  • 2
  • 4
14
votes
3 answers

How to increase column size in Redshift database tables?

In oracle, I can: Alter table table_name modify column_name datatype; Is this possible in a redshift database?
Vinoth _S
  • 857
  • 8
  • 15
  • 24
6
votes
4 answers

Can't DROP GROUP, cannot be dropped because some objects depend on it

RDS Version: PostgreSQL 8.0.2 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.2 20041017 (Red Hat 3.4.2-6.fc3), Redshift 1.0.1161 I've been wrestling with this issue for a few days now, and all solutions I've found here and the AWS Forums aren't…
squeekwull
  • 61
  • 1
  • 3
5
votes
2 answers

Redshift: Return rows if value exists in cell array

How do I return the rows that include a particular value in a column's cell array? Imagine we have a table like so: id name phone values 1 Taylor xxx.xxx.xxxx [4,6,5] 2 John yyy.yyy.yyyy [1,5,2] 3 Peter …
Myg0t
  • 51
  • 1
  • 3
4
votes
1 answer

Amazon Redshift "cache lookup failed for aggregate" error when using median aggregate

I recently ran into this error message and am posting an answer here so that the solution is easily searchable in the future. Problem: The following query returns an error message when run on Amazon Redshift. What does it mean and does Amazon…
Michael Burge
  • 171
  • 1
  • 5
4
votes
1 answer

Redshift throws Value too long for character type character varying(100) even when values are within the range

I am aware what this error message Value too long for character type character varying(100) means. So I often look for the rows which cause the trouble and fix them appropriately as deemed fit by the requirement. But I encountered an odd issue today…
nightgaunt
  • 231
  • 1
  • 2
  • 6
4
votes
0 answers

Redshift: InternalError: cache lookup failed for relation

I have been speaking with Amazon support about this but their only solution is to "keep trying," which has not been successful. The issue is when running our ETL we intermittently get the following error when trying to drop a table: InternalError:…
Alex
  • 141
  • 3
4
votes
1 answer

Redshift - Optimize Expensive Query

I have two tables in Redshift that I am trying to do a join on to get zip code demographics based on a users normalized ip address. By normalized address, I mean that it is concerted to a uniform length string that has the periods stripped out and…
user2694306
  • 121
  • 1
  • 9
3
votes
1 answer

Is Redshift translating "dbo" schema to "public" schema?

We have a strange issue which has appeared in the last couple of days. We have two Amazon Redshift clusters. One cluster has our production workload, and the other cluster has our non-production workload. There are 4 copies of the same database. 1…
Appleoddity
  • 314
  • 3
  • 18
3
votes
1 answer

Redshift: How to fix serializable isolation violation(1023) caused by concurrent MERGE operations?

My use case is to extract, transform and load data incrementally and in real time from x number of Lambda functions. I expect multiple Lambda functions to be running concurrently and Redshift to stay alive for read queries. Since Redshift doesn't…
Andrew Lam
  • 131
  • 4
3
votes
1 answer

Redshift DISTSTYLE ALL table takes less disk space?

(Self-migrating from StackOverflow.) We have a fat table of exactly 591 columns in Redshift, distributed by a key. We were unaware that fat tables chew up space - 2 blocks per column per slice, minimum, and we aren't close to filling up the first…
Thomas Andrews
  • 193
  • 10
2
votes
1 answer

Redshift Spectrum Implicit Unnest of List in Join

I have data that is stored in S3 and I am querying it using SQL via Redshift Spectrum. One of the columns is stored as a list in the S3 file like so: Table_ABC column_a items_list a. [item_1, item_2] b. [item_3, item_4] Redshift has no…
peegee
  • 41
  • 1
  • 6
2
votes
1 answer

Unexpected Redshift support for the ISNULL() function. Is this documented?

As far as I know, the ISNULL() function is only compatible with T-SQL. Yet, I am working on a Redshift cluster, using Datagrip, that accepts the ISNULL() function and returns results without error. I'm even getting the contextual helptext on it in…
dev_etter
  • 751
  • 11
  • 22
2
votes
2 answers

ALTER TABLE ALTER COLUMN cannot run inside a transaction block;

I am trying to alter column in redshift from varchar(30) to varchar(100) Its not working and throwing an error as below: Command used: alter table t_name alter column c1 type varchar(300); Error: [Amazon](500310) Invalid operation: ALTER TABLE…
jagdish
  • 21
  • 1
  • 1
  • 2
2
votes
1 answer

What code underlies the PG_GET_LATE_BINDING_VIEW_COLS sys information function?

We want to transition to late-binding views, but late-binding view metadata is not presented by some clients (workbench/J, Toad, pgcli) which makes it hard to discover column names in these views. AWS provides a function,…
respondeo
  • 21
  • 2
1
2 3 4