<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[qq_38603049的博客]]></title><description><![CDATA[在单线程的世界里，我不太懂代码]]></description><link>https://blog.youkuaiyun.com/qq_38603049</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_38603049]]></copyright><item><title><![CDATA[笔记本电脑外放有声音，插耳机没声音]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/137330597</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/137330597</guid><author>qq_38603049</author><pubDate>Wed, 03 Apr 2024 09:54:27 +0800</pubDate><description><![CDATA[笔记本电脑微信插耳机没声音，怎么办？]]></description><category></category></item><item><title><![CDATA[sql 用like 匹配多个关键词]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/136907889</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/136907889</guid><author>qq_38603049</author><pubDate>Thu, 21 Mar 2024 14:32:43 +0800</pubDate><description><![CDATA[新环境中可能要更改写法 为   REGEXP_LIKE(字段名,'关键词1|关键词2')一般会用   字段名   regexp_like  '关键词1|关键词2'日常还会用到 regexp_like。除了like  的用法。]]></description><category></category></item><item><title><![CDATA[笔记本插入耳机没有声音]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/136835927</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/136835927</guid><author>qq_38603049</author><pubDate>Tue, 19 Mar 2024 11:01:28 +0800</pubDate><description><![CDATA[笔记本耳机没有声音，怎么解决]]></description><category></category></item><item><title><![CDATA[SQL用正则表达式替换 括号以及括号内的内容为空]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/127004284</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/127004284</guid><author>qq_38603049</author><pubDate>Fri, 23 Sep 2022 09:46:37 +0800</pubDate><description><![CDATA[SQL用正则表替换括号以及括号内的内容为空]]></description><category></category></item><item><title><![CDATA[Hive 中的爆炸函数（ lateral view 与 explode 用法）]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/126524196</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/126524196</guid><author>qq_38603049</author><pubDate>Thu, 25 Aug 2022 15:24:10 +0800</pubDate><description><![CDATA[hive中的爆炸函数（ lateral view 与 explode详解），本篇文章主要针对实际应用中的情况，进行讲解]]></description><category></category></item><item><title><![CDATA[笔记本出现数字小键盘怎么解决，出现方形带斜杠123]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/126505818</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/126505818</guid><author>qq_38603049</author><pubDate>Wed, 24 Aug 2022 15:53:48 +0800</pubDate><description><![CDATA[笔记本出现数字小键盘怎么解决，出现方形带斜杠123，如何关闭]]></description><category></category></item><item><title><![CDATA[微信小程序开发教程（一）开发环境的搭建]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/126019418</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/126019418</guid><author>qq_38603049</author><pubDate>Wed, 27 Jul 2022 17:30:16 +0800</pubDate><description><![CDATA[微信小程序开发教程步骤，简单详细]]></description><category></category></item><item><title><![CDATA[DBeaver中如何调整SQL编辑器的字体大小]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/125188696</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/125188696</guid><author>qq_38603049</author><pubDate>Wed, 08 Jun 2022 17:26:19 +0800</pubDate><description><![CDATA[DBeaver中如何调整SQL编辑器的字体大小]]></description><category></category></item><item><title><![CDATA[查看创建的hive表对应的hdfs文件路径]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/123105801</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/123105801</guid><author>qq_38603049</author><pubDate>Sat, 26 Feb 2022 09:56:40 +0800</pubDate><description><![CDATA[查看创建的hive表对应的hdfs文件路径]]></description><category></category></item><item><title><![CDATA[excel中去掉换行符的快捷键]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/121649824</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/121649824</guid><author>qq_38603049</author><pubDate>Wed, 01 Dec 2021 10:43:32 +0800</pubDate><description><![CDATA[excel中如何快速去掉换行符，使用快捷键]]></description><category></category></item><item><title><![CDATA[用python写名字]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/117080571</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/117080571</guid><author>qq_38603049</author><pubDate>Thu, 20 May 2021 18:45:14 +0800</pubDate><description><![CDATA[在这个甜甜的日子里，偷偷告诉大家一个过节日没准备小惊喜绝招，礼物不够，代码来凑
表达爱，一段脚本就够了
先上效果图
一笔一画的自己写出来，感觉良好
很简单的操作，记录一下这个特殊日子
代码如下：
import turtle
from turtle import *

def run(angle, lenth):
    turtle.seth(angle)
    turtle.fd(lenth)

def change(x, y):
    turtle.penup()
    turtle.goto(x]]></description><category></category></item><item><title><![CDATA[HIve  中   collect_list和collect_set  函数的使用总结]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/115962434</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/115962434</guid><author>qq_38603049</author><pubDate>Wed, 21 Apr 2021 16:50:33 +0800</pubDate><description><![CDATA[Hive中collect相关的函数有collect_list和collect_set。
它们都是将分组中的某列转为一个数组返回，collect_list函数不去重而collect_set函数会去重。
例如：有如下一个数据表

进行行转列
很明显我们能看看到，张三做了两次B类项目
1、使用  collect_list函数
select user , collect_list(  project ) from   tb   group by user ;

得到的结果将是

张三的两次B类项目，不会进行去重
2]]></description><category></category></item><item><title><![CDATA[Hive的行转列及列转行函数使用总结]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/115958565</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/115958565</guid><author>qq_38603049</author><pubDate>Wed, 21 Apr 2021 16:24:56 +0800</pubDate><description><![CDATA[1、laterval view  常 和  explode  一起使用用来进行行转列 (单个字段中有多个指定分隔符的字段)
explode  函数我称它为爆炸函数，可以将单个字段中有多个指定分隔符的字
1、比如以下这个 array   这个 例子




array




[10,20,30,40,50]


select explode(array) from tb

结果如下




array




10


20


30


40


50


2、炸开 map  的例子




id
cnt]]></description><category></category></item><item><title><![CDATA[关于sql的正则表达式]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/113771730</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/113771730</guid><author>qq_38603049</author><pubDate>Tue, 09 Feb 2021 16:17:15 +0800</pubDate><description><![CDATA[1、关于正则表达式的四个函数，如下
REGEXP_LIKE  (匹配)
REGEXP_INSTR   (包含)
REGEXP_REPLACE  (替换)
REGEXP_SUBSTR  (提取)
2、在做正则时，做匹配的可能比较多，因此需要了解匹配字符定位
1：定位元字符




元字符
说明




^
使表达式定位至一行的开头


$
使表达式定位至一行的末尾


2、 匹配问题，关于量词或重复操作符

3、表达式的替换匹配和分组

以最近清洗手机号码为例，判断手机号是四大运营商还是固话，做区分匹配规则
]]></description><category></category></item><item><title><![CDATA[SQL基础笔试题（六）]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/112345624</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/112345624</guid><author>qq_38603049</author><pubDate>Fri, 08 Jan 2021 09:59:18 +0800</pubDate><description><![CDATA[1、以下删除记录正确的是（ A ）
A、Delect from emp where name = ‘dony’
B、delete * from emp where name = ‘dony’
C、drop from emp where name = ‘dony’
D、drop * from emp where name = ‘dony’
2、可以在创建表时用（ ）来创建唯一索引，也可以用（C ）来创建唯一索引
A、Create table Create index
B、设置主键约束，设置唯一约束
C、设置主]]></description><category></category></item><item><title><![CDATA[SQL基础面试题（五）]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/112345568</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/112345568</guid><author>qq_38603049</author><pubDate>Fri, 08 Jan 2021 09:54:45 +0800</pubDate><description><![CDATA[1、下列（ C ）不属于连接种类
A、左外连接 B、内连接
C、中间连接 D、交叉连接
2、以下语句错误的是（ A ）
A、alter table emp delete column addcolumn
B、alter table emp modify column addcolumn char(10)
C、alter table emp change addcolumn int
D、alter table emp add column addcolumn int
3、SQL是一种（ C ）语言
A、函数型]]></description><category></category></item><item><title><![CDATA[SQL 基础面试题（四）]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/112324459</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/112324459</guid><author>qq_38603049</author><pubDate>Thu, 07 Jan 2021 19:29:37 +0800</pubDate><description><![CDATA[1、SQL语句中的条件以下哪一项来表达（ C ）
A、THEN B、WHILE C、WHERE D、IF
2、使用CREATE TABLE语句的（ A ）子句，在创建基本表时可以启用全文本搜索
A、FULLTEXT B、ENGINE C、FROM D、WHERE
3、以下能够删除一列的是（ B ）
A、alter table emp remove name
B、alter table emp drop column name
C、alter table emp delete column name
D、al]]></description><category></category></item><item><title><![CDATA[SQL 基础笔试题 （三）]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/112323812</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/112323812</guid><author>qq_38603049</author><pubDate>Thu, 07 Jan 2021 17:32:01 +0800</pubDate><description><![CDATA[1、.在Oracle中，一个用户拥有的所有数据库对象统称为(B).
A.数据库
B.模式
C.表空间
D.实例
2、在oracle中获取前10条的关键字是(D)
A)     top      B）Limit        C）first             D) rownum
3、在Oracle中，(  B  )操作符返回并集操作并不包括重复行
A)  Intersect   B)  Union    C)  Union all   D)  Minus
4、oracle数据库中，通过(  C  )可以]]></description><category></category></item><item><title><![CDATA[SQL基础笔试题（二）]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/112323636</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/112323636</guid><author>qq_38603049</author><pubDate>Thu, 07 Jan 2021 17:29:25 +0800</pubDate><description><![CDATA[1、Hive 默认的构造是存储在(install-dir)/conf/__ ?   B
A    hive-core.xml
B    hive-default.xml
C   hive-site.xml
D    hive-lib.xml
2 Hive 是建立在___之上的一个数据仓库?  C
A   hdfs
B   MapReduce
C   hadoop
D   HBase
3 对于最小粒度的任务，Hive 查询的反应时间约为 ? D
A  几微秒
B  几毫秒
C  几秒
D  几分钟
5 为了启]]></description><category></category></item><item><title><![CDATA[SQL基础笔试题--(一)]]></title><link>https://blog.youkuaiyun.com/qq_38603049/article/details/112323225</link><guid>https://blog.youkuaiyun.com/qq_38603049/article/details/112323225</guid><author>qq_38603049</author><pubDate>Thu, 07 Jan 2021 17:25:49 +0800</pubDate><description><![CDATA[作为考试小白一次次的进行模拟考试，我聪明的把考试题拍照了，机智如我
1、修改表test_tbl字段i的缺省值为1000，可以使用SQL语句（   A    ）
A、ALTER TABLE test_tbl ALTER i SET DEFAULT 1000;
B、ALTER TABLE test_tbl i SET DEFAULT 1000;
C、ALTER TABLE test_tbl MODIFY i SET DEFAULT 1000;
D、ALTER TABLE test_tbl CHANGE i SE]]></description><category></category></item></channel></rss>