- 博客(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
97
原创 Hive 基础介绍
1. Architecture of Hive 2.how hive works Step No. Operation 1 Execute Query The 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
158
原创 R类型转换
R的类型 1. character:"treatment","22","A" 2.numeric:23.44,120,NaN 3.integer:4L,1123L 4.factor:factor("HELLO") 5.Logical:FALSE,TRUE,NA class("")可以显示变量的类型 R类型转换函数as.新的类型: as.character(2016)
2017-08-24 23:12:29
1684
原创 R的包tidyr--数据清洗
Overview of tidyr ** R package **Apply the principles of tidy data ** Small set of the simple functions gather columns into key-value pairs -> wide_df ->gather(wide_df,my_key,my_valu
2017-08-24 19:32:44
356
原创 R的数据清洗
1. view dataset class class(lunch) 2.显示dataset的行数和列数 dim(lunch) 3.显示dataset的列名 names(lunch) 4.看dataset的结构 str(lunch) understanding you data dplyr =>library(dplyr) =>glimpse(lunch) =>su
2017-08-24 18:37:31
253
原创 R连接mysql
##2.load package rm(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
150
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人