<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[fly_skydfdf的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/fly_skydfdf</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; fly_skydfdf]]></copyright><item><title><![CDATA[mac idea tomcat intellj IDE下tomcat catalina.sh error=13, Permission denied和error =1 Operation not pe]]></title><link>https://blog.youkuaiyun.com/fly_skydfdf/article/details/93001276</link><guid>https://blog.youkuaiyun.com/fly_skydfdf/article/details/93001276</guid><author>fly_skydfdf</author><pubDate>Thu, 20 Jun 2019 11:51:05 +0800</pubDate><description><![CDATA[1.问题

 run catalina.sh error=13, Permission denied，
  解决： bin/chmod a+x catalina.sh

2.又出现error =1 Operation not permitted

  解决： xattr -d com.apple.quarantine startup.sh
        xa...]]></description><category></category></item><item><title><![CDATA[hive 常用开窗函数整理]]></title><link>https://blog.youkuaiyun.com/fly_skydfdf/article/details/87281358</link><guid>https://blog.youkuaiyun.com/fly_skydfdf/article/details/87281358</guid><author>fly_skydfdf</author><pubDate>Thu, 14 Feb 2019 17:12:22 +0800</pubDate><description><![CDATA[1、sum()over(partition by ...)   (累加求和)

     select cookieid,create_time,pv,
                sum(pv) over(partition by cookieid order by createtime) as pv1,                   -- 默认为从起点到当前行
           ...]]></description><category></category></item><item><title><![CDATA[sqoop export推送案例]]></title><link>https://blog.youkuaiyun.com/fly_skydfdf/article/details/79020629</link><guid>https://blog.youkuaiyun.com/fly_skydfdf/article/details/79020629</guid><author>fly_skydfdf</author><pubDate>Wed, 10 Jan 2018 10:30:15 +0800</pubDate><description><![CDATA[#!/bin/bash

#ora数据库参数

url=jdbc:oracle:thin:@17.16.1.1:1521:orcl

uid=ods

pwd=xxxxxx

table_name=S02_ASSET_PACKAGE_T1



#Hive_hdfs

hdfs_url=/apps/hive/warehouse/ods.db/s02_asset_package_t1_...]]></description><category></category></item><item><title><![CDATA[sqoop数据抽取 分区表的示例]]></title><link>https://blog.youkuaiyun.com/fly_skydfdf/article/details/79020553</link><guid>https://blog.youkuaiyun.com/fly_skydfdf/article/details/79020553</guid><author>fly_skydfdf</author><pubDate>Wed, 10 Jan 2018 10:26:31 +0800</pubDate><description><![CDATA[--分区表



#!/bin/bash



#mysql表名

tableName=t_sys_file

#字段名

columns=id,biz_field_name,biz_id,biz_table_name,bucket_name,content_type,created_date,disp_order_no,download_times,file_key,file_size,...]]></description><category></category></item><item><title><![CDATA[sqoop数据抽取数据库密码加密]]></title><link>https://blog.youkuaiyun.com/fly_skydfdf/article/details/79020408</link><guid>https://blog.youkuaiyun.com/fly_skydfdf/article/details/79020408</guid><author>fly_skydfdf</author><pubDate>Wed, 10 Jan 2018 10:17:02 +0800</pubDate><description><![CDATA[#创建
hadoop credential create mysql.cock.passwd -provider jceks://hdfs/user/password/mysql.cock.passwd
#删除
hadoop credential delete mysql.cock.passwd -provider jceks://hdfs/user/password/mysql.cock.pas...]]></description><category></category></item><item><title><![CDATA[Hive建表(分区表、非分区表)实例]]></title><link>https://blog.youkuaiyun.com/fly_skydfdf/article/details/79020296</link><guid>https://blog.youkuaiyun.com/fly_skydfdf/article/details/79020296</guid><author>fly_skydfdf</author><pubDate>Wed, 10 Jan 2018 10:12:56 +0800</pubDate><description><![CDATA[--非分区表

USE ODS;

DROP TABLE IF EXISTS s01_t_sys_file;

CREATE TABLE s01_t_sys_file (

 id            STRING COMMENT '自增长列id',

 biz_name      STRING COMMENT '业务名称',

 biz_id  ...]]></description><category></category></item></channel></rss>