I have created a external table in redshift spectrum.Upon running the select * from table_name, i am getting following error SQL Error [XX000]: ERROR: Spectrum
I've been trying to filter the data for the last X number of days. All these columns work as standalone results when I remove the time filter from the where cla
I have a folder containing files in parquet format. I used crawler to create table defined in Glue Data Catalog which counted to 2500+ columns. I want to create
I am ingesting (COPY) json data from S3. Initially storing in a single SUPER column, and then extracting out the individual attributes into a normalised table/c
Suppose I have 2 tables: Table A C_ID P_ID 1 1 1 2 2 1 Table B P_ID 1 2 In Table A, C_ID and P_ID serve as PK, in Table B P_ID
I have a Redshift datawarehouse that is pulling data in from multiple sources. One is my from MySQL and the others are some cloud based databases that get pulle
My company recently migrated to Redshift from Redash recently and I'm having a hard time recreating the YEARWEEK() function available in MySQL but not in Redshi
I'm trying to delete an user from my database but I'm getting an error: user "ted.mosby" cannot be dropped because some objects depend on it Detail: owner of d
The input I have is composed of the following columns: time, UseID, and value. I want to get the plt column as the product of successive numbers. I know about t
Getting the list of users belonging to a group in Redshift seems to be a fairly common task but I don't know how to interpret BLOB in grolist field. I am liter
With a table like: uid | segmentids -------------------------+---------------------------------------- f9b6d54b-c646-4bbb-b0ec
Essentially, I'm trying to figure out the size table foo will be after executing: CREATE TABLE foo AS ( SELECT * FROM my_view ); My gut tells me that the
With a table like: uid | segmentids -------------------------+---------------------------------------- f9b6d54b-c646-4bbb-b0ec
I have the following JSON data. { "recordid":"69", "recordTimestamp":1558087302591, "spaceId":"space-cd88557d", "spaceName":"Kirtipur", "partn
I am trying to populate maximum possible Glue job metrics for some testing, below is the setup I have created: A crawler reads data (dummy customer data of 500
I am new to WLM I have created 2 queues in Manual WLM. now when I am running queries it is throwing the below errors: Amazon Invalid operation: The query cannot
It is my understanding that Redshift is built for performance but not for Availability. The documentation https://aws.amazon.com/redshift/faqs/ suggest that on
while fetching data from database It is working fine when trying to insert data in Redshift database getting exception MY POJO class : Quote.java @Entity publi
I'm trying to insert records on my trying to implement an SCD2 on Redshift but get an error. The target table's DDL is CREATE TABLE ditemp.ts_scd2_test (
I've a status table and I want to fetch the latest details. Slno | ID | Status | date 1 | 1 | Pass | 15-06-2015 11:11:00 - this is inserted first 2