sql standard – How do I group by Quarters in Google big query/dbt?

I have a table with 6 columns and I want to group them by quarters of the year, so far this is my code

SELECT 

DATE_TRUNC(date(timestamp_column), QUARTER),
Column_2,
Column_3,
Column_4,
MAX(column_4),
MAX(column_4)

from table

group by 1,2,3,4 order by 1 desc

This returns the dates in order but they are not grouped by quarter. Does anyone have any idea on the solution to this

[ Politics ] Open Question : You know Donald Trump is in BIG trouble when even Lisa Murkowski won’t support him?

https://www.usatoday.com/story/news/politics/2020/06/04/lisa-murkowski-struggling-trump-mattis-comments/3144321001

themes – twentyseventeen: size in Featured-Image: the size in the desktop view is too big – on mobile (responsive) okay

twentyseventeen: Flip of size in Featured-Image: the size in the desktop view is too big – on mobile (responsive) okay

i have found out that there is a flip – if we watch the site on a mobile phone – then the images look tiny – the proportions are neat and nice. see the awesome comparison i have made in chrome.. see the flip of the both pictures..

enter image description here

btw: see the site: https://www.job-starter.com

enter image description here

My idea on the images was the following: can just not make them parallax by adjusting the styles. They seem to work ok in the mobile width because it turns them into non-fixed images. Using that thinking, i could add this to the “Additional CSS” (at the bottom):

@media screen and (min-width: 48em){

  .background-fixed .panel-image {background-attachment: scroll !important;}

  .panel-image {height: auto !important; max-height: 800px; background-size: contain !important;}

}

That should fix the images on the page.

but it did not.

Note: i run the twentyseventeen – theme with a two column option.

any idea?
see the site: https://www.job-starter.com

big data – Kafka source code on github and from the apache website is missing the “org.apache.kafka.common.message.” package?

I tried downloading the source code of Kafka from Github as well as from Apache’s website. I found that both the sources were missing the “org.apache.kafka.common.message.” package. Can anybody kindly let me know why this might be the case.

Kindly note that I had downloaded the source of “AK RELEASE 2.5.0” from Apache’s website. Similarly I used “trunk” branch from the current github repository for kafka.

A big problem

A big problem
I have a problem with months I could not find a solution.
Our site dramatically declining in the Google search engine, and could not be ousted from the fund in Google .

What are your suggestions
My site: https://pagearabic.com

big o notation – Analysis of Dijkstra algorithm’s (Lazy) running time

I’m trying to figure out the running time for a Dijkstra algorithm. All the sources I have read say that the running time is O(E * log (E)) for a lazy implementation.

But when we do the math we get O(E * (Log(E)+E*Log(E))).

Since E isn’t a constant, I don’t see how someone could reduce this to O(E * log (E).

Are we analyzing the wrong or is it possible to reduce?

        while (!minPQ.isEmpty()) { <=== O(E)
            Node min = minPQ.poll(); <=== O(log(e)

            for (Edge edge : graph.adj(min)) { <=== O(E)
                if (min.getId() == target.getId()) {
                    // Source and Target = Same edge
                    if (edgeTo.size() == 0) edgeTo.put(target, edge);

                    return;
                }

                relax(edge, min, vehicle); <=== log(e) (because of add method on PQ)
            }
      }

Coronavirus is just like the Flu. Why do they make a big deal about it ?

The flu doesn’t kill 100,000 Americans in less than 3 months. The flu doesn’t keep people sick for weeks. Most people who get the flu are back to work after 3 days, not 3 weeks. Most people have some immunity to the flu. Even though the strains are different each year, people with good immune systems usually experience mild symptoms and recover quickly. Some people may not get it at all. Covid is highly contagious, and people have no immunity to it at all.

You may think it’s no big deal, but I don’t think 100,000 people dead just in America is no big deal. If you think that’s just a number or a statistic, how will you feel when you lose a family member? Each of those 100,000 people are someone’s parents, grandparents, husbands, wives, siblings, friends, and children. 

My group is too big for my game, how to manage this situation?

So I may have a happy problem. I just finished a game with a group of five players, all of them enjoyed it and we’ve been talking about the next game we would start. None of them are problem players, none of them will refuse the invitation (I think) and ultimately all of them are fiends and will know if one is excluded.
However, I find five players to be too much for me : due to the nature of the game we play, the kind of situations I like to set up and the time it takes to go through so many people while having some RP in there. All of that is too much for the 2.5-3h sessions we tend do prefer.

So… How can I, as a GM, deal with a group that’s too big for me if I don’t want to force someone out?

In a perfect world, one or two of the players would drop out of the game of their own volitions.
But realistically, I would like to drop one or two, which I don’t know how to go about making it happen, or make the game more manageable for the group I have.


Here are a few complications I have :

  • Everyone is friend of everyone else, so merely not inviting someone is just excluding them and hoping they don’t notice or don’t mind being left out.
  • Likewise, everyone seem to be looking forward to the next setting. So I don’t expect anyone to turn down the game unless there is a big change of playstyle.
  • There are no obvious problem-players. The worst I have are follow-along-players. So I have no real ground to expel anyone.
  • The playstyle I’ve found most enjoyable is one of low-combat and more RP and problem solving. Making kind of hard to engage five people.
  • I also find I like to take the time to RP a bit even when resolving mostly basic rolls, so that resolving a full day’s exploration in a single roll and narating the result is not something I want to do frequently.

I found some question close to mine on the site, the closest I have is this one :How can I manage a party that has grown too big?. But it doesn’t help my problem. Mostly because on the focus on Roll20 and dnd (we run a homebrew system for which the closest comparison I have is : Dungeon World with crunchier combat).


For reference, Here are the main avenues I had in mind in case I still have five players for a while.

  • Run the next game in a Westmarch-like style. Off-loading the burden of who is present to the players and giving me a reason to apply time pressure on the players. I’m not sure how feasable this is and may have to resort to selecting two nights instead of one. Based on our current speed. I can’t see how we could run a satisfying game in such a short time (that is partly my fault).
  • Keep the group and keep a close eye on the playtime IRL, keep things focussed. This is what I’ve been doing and I know it has the side-effect of giving little to no spotlight on the players who goes in the wrong direction and the difference between right and wrong direction is jarring in my narration (and I know some players noticed a few time). If someone decides to leave because of it… I can slow down because I have a more manageable group now. If noone dislike it, then I may be alright. But that is not the kind of game I’d like to run.
  • Keep the group and enforce a strict no-splitting rule. See how it goes. I tend to find 5players+NPCs scenes tough to run and I expect the two least vocal players to just quit talking in such a game. But I can’t find another

Full Press Features on Big Sites for Reputation, Marketing or Verification (Yahoo, IBTimes, etc)

Hi!
Do you have a great product, great business or a fast growing social media account but not getting enough press? We can help!
SEMrush

These articles will be full features about you or your brand. We will also include a picture per article. We will not only publish your article but also write it for you. We can send you the draft document before posting if you prefer too!

The whole process (editing and processing) takes 7 days or less.

For verification (Instagram or Facebook), we recommend 10 articles. If you are getting the articles for Wikipedia, we recommend 12-15.

Here are the prices for our full features:
Yahoo News $350
Yahoo Finance $350
Influencive $700
Latestly $200
Big Time Daily $300
Future Sharks $300
Thrive Global $300
Kivo Daily $300
Disrupt $300
The Frisky $300
IBtimes India $300
Forbes India $750
Clout News $200

We are offering these prices for a limited time, so hurry up if you want to order!
You can pay either through PayPal or BTC.
For questions, please post them over here or DM and we will answer them as fast as possible!

Thank you!

 

json – AWS Big Data Architecture Improvement

I am working on a big data project to group and analyze large volumes of data scraped from the web in daily batches. The data is currently stored in S3 buckets and is tagged based off of a single specific property. References to files are grouped together and stored in DynamoDB based on the single property. The data is then loaded into ElasticSearch and is served to a web app.

The current architecture is:

Current Architecture

I am looking to change the architecture to allow JSON documents to be grouped based on more complex logic, rather than on a single property. For example, rather than merging into DynamoDB based on schema1.property1 == schema2.property2, I would like to group records by:
(schema1.property1 == schema2.property2) && (schema1.property1 > schema2.property3)

Potential Solution:

enter image description here
I am new to big data processing and am looking to build a solution that scales well. From my research, my initial thought is to run a daily Spark job on AWS EMR to load and join the JSON data based on the the necessary logic. While it seems feasible, I do not have experience in if Spark best suited for this or if I should use another framework/tool. Any advice would be greatly appreciated.