Oracle (Basic Grammar)

1. Functions 1.1 case conversion function function describe LOWER() All lowercase UPPER() uppercase INITCAP() title case 1.2 String Operating Functions function describe concat() Split String Substr (field, startIndex,endIndex) substr length() String Length Instr (field,'character') Location index where specified characte ...

Posted by speedyslow on Thu, 23 Apr 2020 05:04:22 +0200

Which is the best way to schedule jobs? Quartz was chosen

*With the advent of cloud platforms, big data, etc., users or potential visitors increasingly want to experience products for free, especially to apply for a system (such as turning on virtual machines, starting docker, etc.). However, the system hardware resources are limited. How can users actually operate cloud platform resources? That is a ...

Posted by nigeledge on Fri, 10 Apr 2020 18:47:52 +0200

Interpretation of FlinkKafkaConsumer011 method

FlinkKafkaConsumer011.setStartFromEarliest() /** *Specifies that consumer reads from the earliest offset of all partitions. *This method causes consumer to ignore any submitted offset s in Zookeeper / Kafka brokers. * *When consumer is restored from checkpoint or savepoint, this method does not work. In this case, the offset in the r ...

Posted by malec on Fri, 10 Apr 2020 13:33:32 +0200

Phoenix + HBase, let you operate HBase like MySQL

Operation of Phoenix associated HBase (three cases) Situation 1: Hbase already has existing tables. You can create corresponding views in Phoenix. Views can only be queried, not added, deleted or modified Table has been created and data exists in hbase, table name: phoenix Create the corresponding view in phoenix create view "phoenix"( pk ...

Posted by estero2002 on Wed, 01 Apr 2020 21:47:10 +0200

Wu university students use Python to knock out Cherry Blossom open (with source code)

Yunqi information:[ Click to see more industry information]Here you can find the first-hand cloud information of different industries. What are you waiting for? Come on! This year's Wuhan University is not as crowded as before, but the beautiful cherry blossom is still blooming alone in spring Wuda has opened a live broadcast of Cherry Blossom ...

Posted by vidhatanand on Wed, 25 Mar 2020 10:32:13 +0100

The impact of large compressed files on the query performance of Impala

Hadoop/HDFS/MapReduce/Impala is designed to store and process a large number of files, such as terabytes or petabytes of data. A large number of small files have a great impact on the query performance, because NameNode needs to save a large number of HDFS file metadata. If it queries many partitions or files at one time, it needs to obtain the ...

Posted by shane0714 on Sat, 21 Mar 2020 10:54:37 +0100

Initial installation experience of GaussDB 100 stand alone

The traditional database technology based on single machine has been unable to support the access processing of massive data. In this case, the database cluster gausdb 100, which supports the high expansion of the system and strong consistency of the sub database and sub table Sharding architecture, came into being. It is a distributed system ...

Posted by vinylblare on Wed, 11 Mar 2020 06:22:49 +0100

ElasticSearch word breaker, take a look

This article mainly introduces what is Analysis, what is the word breaker, and how the word breaker of ElasticSearch works. Finally, it will introduce how to do the Chinese word breaker. First of all, what is Analysis What is Analysis? As the name implies, text Analysis is the process of converting the full text into a series of words (term/tok ...

Posted by Danno13 on Sun, 08 Mar 2020 13:58:31 +0100

SQL Server import performance comparison -- Parallel Import

With the emergence of big data and a large number of data systems, data loading has become more and more important. Many jobs even need ETL skills. However, today, data loading is no longer a simple ETL, but also ELT, and even does not need data mobile computing. This paper first focuses on the traditi ...

Posted by steve490 on Mon, 02 Mar 2020 05:01:53 +0100

Ajax crawls to the top of today's street shooting improvement -- various minefield solutions including data:none problem

Ajax crawls to the top of today's street shooting improvement -- various minefield solutions including data:none problem This BUG is self-taught crawler to prepare for big data. Due to the progress of the times, all websites have strengthened anti climbing measures, and the teaching of books in the le ...

Posted by kaoskorruption on Fri, 07 Feb 2020 10:19:03 +0100