- 博客(6)
- 收藏
- 关注
原创 Hive常用函数
1.修改表:ALTER TABLE table_name SET TBLPROPERTIES('comment' = '这是表注释!');2.修改字段:ALTER TABLE table_name CHANGE COLUMN muid muid_new STRING COMMENT '这里是列注释!'; 3.json字段解析(get_json_object)select ...
2018-08-18 15:34:49 108
原创 Hive 基础介绍
1. Architecture of Hive2.how hive worksStep No. Operation1Execute QueryThe Hive interface such as Command Line or Web UI sends query to Driver (any database driver such as JDBC, ODBC
2017-08-25 16:04:30 164
原创 R类型转换
R的类型1. character:"treatment","22","A"2.numeric:23.44,120,NaN3.integer:4L,1123L4.factor:factor("HELLO")5.Logical:FALSE,TRUE,NAclass("")可以显示变量的类型R类型转换函数as.新的类型:as.character(2016)
2017-08-24 23:12:29 1714
原创 R的包tidyr--数据清洗
Overview of tidyr** R package**Apply the principles of tidy data** Small set of the simple functionsgather columns into key-value pairs-> wide_df->gather(wide_df,my_key,my_valu
2017-08-24 19:32:44 365
原创 R的数据清洗
1. view dataset classclass(lunch)2.显示dataset的行数和列数dim(lunch)3.显示dataset的列名names(lunch)4.看dataset的结构str(lunch)understanding you datadplyr=>library(dplyr)=>glimpse(lunch)=>su
2017-08-24 18:37:31 279
原创 R连接mysql
##2.load packagerm(list=ls())library(RSQLite)library(proto)library(gsubfn)library(sqldf)library(DBI)library(RMySQL)strategydb=dbConnect(dbDriver("MySQL"), user = "strategydb_w"
2017-08-23 18:26:29 155
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人