Hi Sravan, very nice explaation , this is Pradeep Kumar Reddy can you please share your contact details , i will reach you. i am your ex-employ in mahindra Satyam.
Hi Sravan, hope your doing good. i am very happy to see your channel. i am your ex-employee in mahindra satyam. can you please share your contct details. i wll call you. i saq your aws redshift youtube.
Using LISTAGG is giving error as *SQL Error [XX000]: ERROR: One or more of the used functions must be applied on at least one user created tables. Examples of user table only functions are LISTAGG, MEDIAN, PERCENTILE_CONT, etc*
With all due respect. Let me tell you why your tutorials suck. Lets assume you are a chief. But you cannot cook Chinese food. So you decide to pull some tutorials from RU-vid. In the videos, the guy is in an office not a kitchen. He is babbling on and on and on .. bla .. bla ... bla .. "Hold the fish in a diagonal angle, and the knife perpendicular to the tail bone" he says. You are like why the fck is not he showing me instead of all this worthless talk. And you are thinking that the idiot does not know that customers will pay you TO COOK not talk. Spin a fckin IDE or a cloud environment and show us how it is done man. Or shut the fck up and stop wasting people's time man. Or, Get a fckin PhD so you can babble for hours about worthless sht no one cares about my friend....
Someone had to do the hard work if not the creator, be it the Viewer: WLM Monitoring Query: Select (config.service_class-5) as queue, trim(class.condition) as description, config.num_query_tasks as slots, config.query_working_mem as mem, config.max_execution_time as max_time, config.user_group_wild_card as "user_*", config.query_group_wild_card as "query_*", state.num_queued_queries as queued, state.num_executing_queries as executing, state.num_executed_queries as executed, from STV_WLM_CLASSIFICATION_CONFIG class, STV_WLM_SERVICE_CLASS_CONFIG config, STV_WLM_SERVICE_CLASS_STATE state where class.action_service_class = config.service_class and class.action_service_class = state.service_class and config.service_class > 4 order by config.service_class; WLM slots & memory query: select name, service_class, num_query_tasks as slots, query_working_mem as memory from STV_WLM_SERVICE_CLASS_CONFIG;