Styjun

Is it possible to change paper title after send back from reviewers for revising?

What other tricks were there to get more data onto floppy disks?

Prevent function taking const std::string& from accepting 0

Euclidean Distance Between Two Matrices

Can Veil of Summer force an opponent to target their own creatures with Swift End when Lucky Clover is on the battlefield?

Did Ohio pass a law granting students the right to give scientifically wrong answers consistent with their religious beliefs?

How can I find out where to buy uncommon (for the location) items while traveling?

Why does this process map every fraction to the golden ratio?

Ethics: Is it ethical for a professor to conduct research using a student's ideas without giving them credit?

Beautiful planar geometry theorems not encountered in high school

Are we experiencing lower level of gravity now compared to past?

How would you idiomatically translate the French saying "Il n’y a pas d'amour, il n’y a que des preuves d’amour" to English?

UK visitors visa needed fast for badly injured family member

"Startup" working hours - is it normal to be asked to work 11 hours/ day?

Is a Fourier transform a sound way to analyse a transient signal?

Is there such a thing as Intrusive-L (as opposed to Intrusive-R)?

What does Yoda's species eat?

Earth magnetic field space elevator. No cable

Locked folder with obscure app from Sourceforge, now cannot unlock folder

Why would one use "enter the name of the project to confirm"?

Do time signatures make sense?

Many if's with simple comparison. Feels very redundant

How do you get the Super Rod in Pokémon Sword and Shield?

Magento2.3: How to move the custom block in account navigation sidebar?

Allowing for weekends (daofweek = 7, dayofweek = 1) in case when clauses

impala-shell just hangs when invoked in cliCase when for subset and the whole setImpala max() over a window clauseWould view or with clause of impala just compute once and be used multiple times in a query?Modify left join clauseCase when with else for every 'When' conditionImpala ODBC Driver Syntax Error (Encountered DECIMAL LITERAL)Impala AnalysisException: Subqueries are not supported in the HAVING clause

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty
margin-bottom:0;

0

Here is a sample table :

 date type value
 3/28/2019 0:00 c_amt 0.02
 3/29/2019 0:00 c_amt 0.03
 3/30/2019 0:00 c_amt 0.05

I have the following CASE WHEN clauses in my query:

 CASE WHEN to_date(date) = to_date(cast('2019-03-28' as timestamp)) AND type = 'c_amt' 
 THEN value ELSE 0
 END AS c_amt1,
 CASE WHEN to_date(date) = to_date(date_add(cast('2019-03- 
 28' as timestamp), 1)) AND type = 'c_amt' 
 THEN value ELSE 0 
 END AS c_amt2, 
 CASE WHEN to_date(date) = to_date(date_add(cast('2019-03-28' as timestamp), 2)) AND type = 'c_amt' 
 THEN value ELSE 0 
 END AS c_amt3 

Now I am trying to add special condition for weekends. 3/30/2019 happens to be Saturday. dayofweek 7 in Impala terms.

I need to add the following logic: for dayofweek 7 (Saturday) get value from pervious day. For dayofweek 1 (Sunday) get value from 2 days before. Saturday and Sunday should have Friday's value. How do I achieve that?

impala

share|improve this question

edited Mar 28 at 22:23

Ella

asked Mar 28 at 22:08

EllaElla

122 bronze badges

add a comment
 | 

0

Here is a sample table :

 date type value
 3/28/2019 0:00 c_amt 0.02
 3/29/2019 0:00 c_amt 0.03
 3/30/2019 0:00 c_amt 0.05

I have the following CASE WHEN clauses in my query:

 CASE WHEN to_date(date) = to_date(cast('2019-03-28' as timestamp)) AND type = 'c_amt' 
 THEN value ELSE 0
 END AS c_amt1,
 CASE WHEN to_date(date) = to_date(date_add(cast('2019-03- 
 28' as timestamp), 1)) AND type = 'c_amt' 
 THEN value ELSE 0 
 END AS c_amt2, 
 CASE WHEN to_date(date) = to_date(date_add(cast('2019-03-28' as timestamp), 2)) AND type = 'c_amt' 
 THEN value ELSE 0 
 END AS c_amt3 

Now I am trying to add special condition for weekends. 3/30/2019 happens to be Saturday. dayofweek 7 in Impala terms.

I need to add the following logic: for dayofweek 7 (Saturday) get value from pervious day. For dayofweek 1 (Sunday) get value from 2 days before. Saturday and Sunday should have Friday's value. How do I achieve that?

impala

share|improve this question

edited Mar 28 at 22:23

Ella

asked Mar 28 at 22:08

EllaElla

122 bronze badges

add a comment
 | 

Here is a sample table :

 date type value
 3/28/2019 0:00 c_amt 0.02
 3/29/2019 0:00 c_amt 0.03
 3/30/2019 0:00 c_amt 0.05

I have the following CASE WHEN clauses in my query:

 CASE WHEN to_date(date) = to_date(cast('2019-03-28' as timestamp)) AND type = 'c_amt' 
 THEN value ELSE 0
 END AS c_amt1,
 CASE WHEN to_date(date) = to_date(date_add(cast('2019-03- 
 28' as timestamp), 1)) AND type = 'c_amt' 
 THEN value ELSE 0 
 END AS c_amt2, 
 CASE WHEN to_date(date) = to_date(date_add(cast('2019-03-28' as timestamp), 2)) AND type = 'c_amt' 
 THEN value ELSE 0 
 END AS c_amt3 

Now I am trying to add special condition for weekends. 3/30/2019 happens to be Saturday. dayofweek 7 in Impala terms.

I need to add the following logic: for dayofweek 7 (Saturday) get value from pervious day. For dayofweek 1 (Sunday) get value from 2 days before. Saturday and Sunday should have Friday's value. How do I achieve that?

impala

share|improve this question

edited Mar 28 at 22:23

Ella

asked Mar 28 at 22:08

EllaElla

122 bronze badges

 date type value
 3/28/2019 0:00 c_amt 0.02
 3/29/2019 0:00 c_amt 0.03
 3/30/2019 0:00 c_amt 0.05

 CASE WHEN to_date(date) = to_date(cast('2019-03-28' as timestamp)) AND type = 'c_amt' 
 THEN value ELSE 0
 END AS c_amt1,
 CASE WHEN to_date(date) = to_date(date_add(cast('2019-03- 
 28' as timestamp), 1)) AND type = 'c_amt' 
 THEN value ELSE 0 
 END AS c_amt2, 
 CASE WHEN to_date(date) = to_date(date_add(cast('2019-03-28' as timestamp), 2)) AND type = 'c_amt' 
 THEN value ELSE 0 
 END AS c_amt3 

share|improve this question

edited Mar 28 at 22:23

Ella

asked Mar 28 at 22:08

EllaElla

122 bronze badges

share|improve this question

edited Mar 28 at 22:23

Ella

asked Mar 28 at 22:08

EllaElla

122 bronze badges

asked Mar 28 at 22:08

EllaElla

122 bronze badges

asked Mar 28 at 22:08

EllaElla

122 bronze badges