Questions tagged [apache-spark]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
0answers
16 views

RDDs, Maps and Apache Spark

I have been playing around with Apache Spark, firstly I learned PostgreSQL and I have a few queries that I needed to run on Spark. I managed to run them as SQL Strings in Spark SQL, but now I have to ...
0
votes
1answer
144 views

Fill in missing dates with data value from previous populated date

Given a table with date and ramp%. I would like to add the missing dates with previous ramp% Table and sample data: +------------+-------+ | date | ramp% | +------------+-------+ | 01-01-2016 |...
0
votes
0answers
23 views

Move from SSIS to Azure

I have an ETL solution which we have been doing in conventional SSIS. The job of SSIS is just to create star schema from the application database to dimension and fact tables. There is very little ...
0
votes
1answer
177 views

How to use case and filter with a group by statement and having an aggregate calculation?

I would like to do the following SELECT PO.col1, PO.col2, CASE WHEN PO.col3 <> 8 THEN PO.col4 WHEN PO.col3 = 8 THEN CASE WHEN (ROUND(CAST(...