Database Administrator

Use Hive's regular parser RegexSerDe to analyze Nginx logs 1. Environment: Hadoop-2.6.0 & apache-hive-1.2.0-bin 2. Use Hive to analyze nginx logs. The website access logs are as follows: Cat/home/hadoop/hivetestdata/nginx.txt192.168.1.128--[09/Jan/20

Oracle Database high-risk vulnerability warning! Users have recently exposed an Oracle high-risk vulnerability on the Internet. Users with only query permissions can add, delete, and modify data, which is very dangerous. This vulnerability has a

Php accesses the mysql database and phpmysql Database PHP can access the Mysql database through the mysql interface and mysqli interface. You must add the mysql and mysqli interfaces to access the mysql database. In windows, configure amp: a and

For more information, see .   -------------- Note: The following operations are performed in rhel vnc, not in secureCRT. -------------------------- Cause: If it is executed in secureCRT, m Lu will be shown as: m Lu. See the following. Why? I

[SQL] -- triggers, SQL triggersConcept Trigger is a method provided by SQL server to programmers and data analysts to ensure data integrity. It is a special stored procedure related to table events, its execution is not called by a program, nor is

Oracle Policy For NBU, policynbuTheory: NBU use a automatic script to connect RMAN and backup database Steps:First, make a automatic script.Second, build a oracle policy First:Make a automatic script. NBU has provide some scripts on it's client

Mysql optimization and mysql Performance Optimization 1. view the mysql server configuration information show variables. You can also use show variables like 'key % '. 2. view the status values of the mysql server running show status, which is the

ORA-19706: invalid SCN, ora-19706scn Today's site dblink reported ORA-19706: invalid SCN, database versions are 11.2.0.4. After checking metalink, the two databases will synchronize the scn number when accessing through dblink. The result of SCN

Common commands of MongoDB First, install the database. You can use windows or linux, but linux is recommended. I use ubuntu12.04. you can download the database at the following URL, it is usually a 64-bit system. If you use a linux system, you can

Error Code: 1414. OUT or INOUT argument 2 for routine company. new_procedure is not a variable or NEW, too loginout 1. Error description 16: 27: 36 call new_procedure (20150112,1) Error Code: 1414. OUT or INOUT argument 2 for routine company.

Converts column data separated by commas (,) in a column into a function for displaying row data. This is an example of a string segmentation function. select to_number (strvalue) as Value from table (fn_split ('1, 2, 3 ', ',') select to_char

SQL language division, SQL language divisionIn terms of functions, the SQL language can be divided into three categories: DDL, DML, and DCL.1. DDL (Data Definition Language)Data Definition Language, used to define and manage the languages of all

More depressing than ORA-24777: do not allow the use of unportable database links, ora-24777 linksAn error is reported when the synchronization function is on site. The content is as follows: java. SQL. BatchUpdateException:ORA-24777: do not allow

In windows, PHP cannot enable pgsql extension. phppgsql Tip: Windows 8.1 64-bit + xampp1.8.1 + postgresql 9.3.6-2 Step 1: In php. ini, enable the pgsql extension = php_pgsql.dll (if the pdo connection enables extension = php_pdo_pgsql.dll) Step 2

Filter conversion can be optimized at one time, and filter conversion can be optimized. There is a problem with SQL Performance. When a filter is found in the execution plan, you should be careful when it comes to it. Like nestloop, my previous blog

Mysql Stored Procedure transaction rollback and mysql Stored Procedure transaction SQL Process Code: DELIMITER $$CREATE DEFINER=`root`@`localhost` PROCEDURE `test_procedure`()BEGINDECLARE errno int;declare continue HANDLER for sqlexceptionbegin

Large set of basic SQL statements and large set of SQL statements Every time I used to use SQL Sever to directly design the database, but did not pay enough attention to the SQL statements. I took the opportunity of restructuring the cooperative

Oracle basics-Introduction (first meeting) and oracle first meetingI. Overall introduction: Oracle databases and databases represent the basis of all Oracle database objects. Oracle is a large-scale relational database based on advanced Structured

Implement HTTP storage plugin and drillplugin in Drill Apache Drill can be used for real-time big data analysis: Inspired by Google Dremel, Apache's Drill Project is a distributed system that performs Interactive Analysis on large datasets. Drill

Freeze file header, freezefileheaderSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionWe can use