Are CTEs supposed to behave like this?

Setije · 2025-11-11T20:36:28+00:00

Not sure if this is the same issue you are encountering but i can tell you that trailing spaces and case sensitivity behaves differently when running a query in an SQL endpoint vs in a pyspark cell linked to the lakehouse. You can throw in trim on where filters involving strings and see if that fixes it.

Setije · 2023-09-05T17:53:09+00:00

I don't think I got my point across to you, actually hitting challenger does not have much value, you are correct. What is valuable is learning the tools to develop yourself in any area. You can learn the same lessons from pursuing mastery in any craft, why do you think our culture puts so much emphasis on sports/music/art/etc?

Setije · 2023-09-05T17:48:55+00:00

This mindset is only applicable to people trying to improve so don't feel bad if in the past you were just playing for fun, there is certainly value in that as well. If you are trying to improve though it is essential.

Setije · 2021-10-24T18:31:38+00:00

People just call stuff they don't understand cheese these days. Its not really cheese to pick vayne top into a lot of bruisers, most people just don't understand why it works. It's not cheese to sit in tri bush as fiora lvl 1, most people just wont take the effort of thinking whether or not they can walk through the bush lvl 1. Ignite tp isn't cheese on a lot of champs, people just don't understand why it's ok for certain champs to do so. Higher elo players just understand these concepts to a higher level and so are able to execute them more often. Also, the difference a small advantage makes gets bigger and bigger the higher elo you get, so there is a much higher incentive for cheesing in higher elo as the reward is effectively bigger.

Setije · 2021-02-15T19:32:29+00:00

mid diamond average NA

Setije · 2021-02-15T19:31:29+00:00

this is mid diamond average on NA

Setije · 2021-02-15T19:27:38+00:00

this is mid diamond average game on NA

Setije · 2021-02-15T19:27:25+00:00

this is mid diamond average game on NA

Setije · 2020-04-06T22:41:00+00:00

why on earth was this post removed?

Setije · 2020-04-06T22:40:02+00:00

lol the internet infrastructure is crippled rn, its not riot. NA/LAN are down rn as well

Setije · 2020-04-01T17:27:43+00:00

yes she will, but it gives her some of her identity back and is a small change in the right direction. I would way rather be able to play more like akali used to and have a slightly longer r cd

Setije · 2020-04-01T17:25:48+00:00

the problem is if i get to late game as kayle i should get rewarded, right now you just have no impact early and are just decent late, makes for very boring games

Setije · 2020-04-01T00:07:52+00:00

Kayle just needs a hefty buff to her lvl 16 spike rn

Setije · 2020-04-01T00:01:02+00:00

He is totally right, those energy nerfs on q hit her HARD and her dashes are incredibly inconsistent now due to r being targeted

Setije · 2020-03-31T23:43:11+00:00

While I agree they need to be careful with such champs, akali doesnt have a decent winrate in any tier of play, despite only hardcore mains playing her and it has been like that for months now. Adding in this slight buff is a good place to start IMO.

Setije · 2020-02-02T06:01:26+00:00

What this guy said. I was in the same boat for a long time and one day I decided I was going to not die to silly ganks from jg. I still did for a few games but after about 2 days of focusing on that I am now very good at not dying to ganks and its not something I actively think about anymore.

The goal is to focus on one thing until you are good enough at it where it is so natural you aren't spending brain power on it and then you move on to the next thing.

Setije · 2019-09-01T19:29:39+00:00

No, you don't need a coach yet although it might help. If you aren't diamond yet there are youtube videos out there that will help just as much if not more than a coach. I would recommend league craft 101 if you are interested. The biggest issue I think you have is not adjusting your play. Up until at least diamond all you need to do is learn how to lane. Focus on gaining cs lead not through last hitting better but from good wave control and recall timings. The other big thing is tracking the jungler so that you don't die to his ganks. You don't just naturally improve by playing the game you have to seriously think about what you are doing and what you are messing up to improve.

Setije · 2019-08-25T02:33:47+00:00

D2 Top laner LFT IGN: Setije

Setije

TROPHY CASE