JnYoung的博客

------------------------------------------------- 子查询用in，结果正确；而not in 子查询结果必须key（id）中没有null值存在，最终结果才正确with a as ( select 1 as id, "a1" as name union all select 2 as id, "a2" as name union all select 3 as id, "a3" as name ),b as( selec

给定数组[4,5,6,7,8,9,0,1], 在时间复杂度logn限制下，找出n是否在该数组中，如果在返回索引位置，如果不在返回-1

加粗样式package com.jn.learning.javalearning.thread;/*************************************************************************** * * Written by TankPush (Jn) * DATE: 2020-05-24 23:55 * * Description: 实现多个线程间交替打印，如在100以内，每个线程每打印10次，然后交换 * * *********

实现Runnable接口相对继承Thread要简洁些package com.jn.learning.javalearning.thread;/*************************************************************************** * * Written by TankPush (Jn) * * Description:窗口卖票（多线程操作同一份共享数据，实现线程间通信） * 1、定义总票数：共享数据 * 2、定义卖票功能：同步

Kafka群起脚本#!/bin/bashfor i in `cat /opt/module/hadoop-2.7.2/etc/hadoop/slaves`dossh $i 'source /etc/profile && /opt/module/kafka_2.11-0.11.0.2/bin/kafka-server-start.sh -daemon /opt/module/kafka_2.11-0.11.0.2/config/server.properties'if [ $? -

转自下面链接https://www.jianshu.com/p/61e539b790e3

Pom文件中添加如下配置添加新依赖的操作在Maven项目发生变化而自动update时，依然会被重置，因此需要保证上面的设置版本号是对的即可，最根本的解决方案就是在pom.xml文件中指定项目编译的Java版本，即maven-compiler-plugin的版本，该版本会影响Language Level和JavaCompiler，修改后项目默认就使用了该配置<build> <plugins> <plugin> <

SparkStreaming<dependency> <groupId>org.apache.spark</groupId> <artifactId>spark-streaming_2.11</artifactId> <version>2.1.1</version></dependency>

package com.jn.learning.algorithm.sort;import java.util.Arrays;import java.util.Random;/*************************************************************************** * * * Written by TankPush (Jn) * Description:冒泡排序: * 优化点： * 1、一轮内部遍历排序后，查看标志位是否无改

package com.jn.learning.algorithm.sort;import java.util.Arrays;import java.util.Iterator;import java.util.TreeSet;/***************************************************************************** * * * Written by TankPush (Jn) * * Description: 对给定数组

从struct 类型的 named_struct_1字段 解析其中内容：page_id, page_name, log_datecreate table tmp_user_scan_info_struct_mid stored as orc asselect uid, named_struct('page_id', page_id, 'page_name', page_name, 'log_date', log_d

----------第一种 完整map结构的string类型： 查看原始表的表结构和数据 ------------hive> select * from test_map_1_to_string;uid string11 {"key1":"value1,key2":"value2"}2 {"key3":"value3,key4":"value4"}-------------------------------- 错误 HiveSQL ---------------------------

create_union

数据表和需求表名：student， 结构和具体内容如下：name course scorezs Math 100zs Engl 80ls Math 90ls Engl 70需求如下：1、获取每个人最高分对应的学科和分数（方式一：使用row_number()开窗函数；方式二：不用开窗函数，使用join方式）2、获取每门课程都高于平均分的人、课程和分数数据准备set hive.exec.mode.local.auto=true;set hive.c

--上传测试数据drop table test_map_1;create table test_map_1 asselect 1 as uid, map("key1", "value1","key2", "value2") as map1 union all select 2 as uid, map("key3", "value3","key4", "value4") as map1;--查看当前测试表结构是否是map<string,string>类型hive> desc t

使用HiveSQL实现 任意N天中有M天登录的需求：具体举例，***任意7天达到3天登录***可以翻译为：当前次登录时间 与 第3次登陆的时间 的差值在7天内WITH user_info as(select 1 as user_id, '2020-01-01' as log_date union allselect 1 as user_id, '2020-01-02' as log_date union allselect 1 as user_id, '2020-01-03' as log_dat

查询sql：select tmp.*, t1.t1_sku_id, t2.t2_order_numfrom( select 1 as uid, 'a,b,c' as sku_id, '10,20,30' as order_num union all select 2 as uid, 'a,b,c,d' as sku_id, '10,20,30,40' as order_num)tmplateral view outer posexplode( spl

查询1：set hive.exec.mode.local.auto=true; --开启本地模式set hive.cli.print.header=true; --打印表.列名select tmp.*, t.*, date_add(start_date, pos) as mid_datefrom( select '1' as uid, '2020-01-01' as start_date, '2020-01-05' as end_date

package com.jn.learning.javalearning.singleton;/********************************************************************************************** * * * Written by TankPush (Jn) * * Description: * 静态内部类方式 * 线程安全，且懒加载 * * *****************************

package com.jn.learning.javalearning.thread;/********************************************************************************************** * * * Written by TankPush (Jn) * * Description: * 生产消费者问题：线程间通信 * 生产者生产产品，消费者消费产品， * 中间环节中店员负责二者间联系，当数量少于10