hive
今天我有更博学吗?
数据分析爱好者
展开
-
hive电商数据分析
创建表:CREATE TABLE tbDate(dateID string,theyearmonth string,theyear string,themonth string,thedate string,theweek string,theweeks string,thequot string,thetenday string,thehalfmonth string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LINES TERMINATED BY .原创 2020-11-21 15:48:57 · 987 阅读 · 0 评论 -
把本地文件上传到远程服务器,在hive中创建表并导入数据
文章目录一、scp命令上传文件/文件夹二、macOS登录远程服务器三、进入hive窗口四、hive中创建表五、向创建表中导入txt文件一、scp命令上传文件/文件夹可以选择:上传一个文件:scp -r /path/filename username@servername:/path上传一个文件夹:scp -r /path/folder username@servername:/path 打开一个文件夹遍历上传里面所有文件:scp -r /path/folder/* user原创 2020-11-17 23:20:04 · 1102 阅读 · 0 评论