Blog

REGEX SQL

As you know regex is a powerful string manipulation function used to filter the strings,numbers,characters etc very effectively. Below are the useful functions to pull desired filter REGEXP_SUBSTR REGEXP_SUBSTR(source_string,pattern [,position[,occurence[,return_option[,match_parameter]]]] [[:digit:]] is a parameter used in regex_substr to filter only digits from string REGEXP_LIKE is a function which can be used in where clause of … Continue reading REGEX SQL

HDFS not starting : java.io.IOException: the path component: ‘/var’ is owned by a user who is not root and not you. Your effective user id is 993; the path is owned by user id 977, and its permissions are 0755. Please fix this or select a different socket path. at org.apache.hadoop.net.unix.DomainSocket.validateSocketPathSecurity0(Native Method)

Cause: HDFS is not starting from cloudera because of permission error after installing spark. After spark is installed, the ownership of /var mountpoint change to spark:spark Workaround: Change the owner to root Check the ownership

SQL QUERY TO FIND PROCESS AND SESSION RESOURCE LIMIT ORACLE

If there concurrent sessions and process connections overflow in your database,then you might get into trouble of customer complaint because of performance or connectivity issues. This query will help you to get limit compared with current and max utilization of processes and sessions SQL Query: Output:

Loading…

Something went wrong. Please refresh the page and/or try again.


Follow My Blog

Get new content delivered directly to your inbox.