python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - data-partitioning

Row level trigger returning NULL causes ERROR: query has no destination for result data

I have created a before insert trigger that should insert the data into either an existing table partition or create a new partition and then insert the data. I see that the partition is created but t...
test-img

Wolfgang

triggers

data-partitioning

Votes: 0

Answers: 1

Latest Answer

Ok, finally found it. The issue was that the statement SELECT create_partition('historytrails', NEW.created); should have been: PERFORM create_partition('historytrails', NEW.created);
test-img

Wolfgang

Reading spark partitioned data from directories

My data is partitioned as Year,month,day in s3 Bucket. I have a requirement to read last six months of data everyday.I am using below code to read the data but it is selecting negative value in months...
test-img

code_bug

apache-spark

pyspark

databricks

data-partitioning

Votes: 0

Answers: 1

Latest Answer

You can use a list of addresses (strings) as your .load() argument. First you can create the list for six months backward (from today): from datetime import date from dateutil.relativedelta import rel...
test-img

Ala Tarighati

Posts

Questions

Blogs

Jobs