Comments (9)
有两种方式导入到hive:
- hive类型,hive版本支持ACID的,可以单条写入
- file类型,按照格式生成数据文件,然后上传文件到hdfs
from datafaker.
有两种方式导入到hive:
- hive类型,hive版本支持ACID的,可以单条写入
- file类型,按照格式生成数据文件,然后上传文件到hdfs
您好。 请问一下第2种形式是不是这种套路:datafaker rdb mysql+mysqldb://root:root@localhost:3600/test?charset=utf8 stu 10 --outprint --meta meta.txt --outspliter ',,' >> file
然后再把这个file扔到hive里?(不过我发现这样生成的文件是每行的头尾都有带[] 好像要处理了才能导入hive)
另第1种形式是什么意思?
from datafaker.
datafaker file /home out.txt 10 --meta meta.txt
请仔细阅读文档其他参数和使用举例
from datafaker.
额好吧,还有 我打印出来到屏幕上的数据是这个样子的~~
[1, u'OyBYxUtPDnBEHoW', u'\u65e7\u5927\u9662', u'\u9b3c\u6ce3', 52, 17, 63.41, u'15737968987', u'[email protected]', '192.88.21.168', u'\u5b81\u590f\u56de\u65cf\u81ea\u6cbb\u533a\u7389\u82f1\u5e02\u84df\u5dde\u4e1c\u839e\u8defX\u5ea7 730082']
[2, u'SPVQwwjbVzfJBtblXL', u'\u65e7\u5927\u9662', u'\u9017\u6bd4', 19, 20, 39.53, u'13044617779', u'[email protected]', '169.255.220.229', u'\u798f\u5efa\u7701\u6d69\u53bf\u5357\u6eaa\u798f\u5dde\u8deff\u5ea7 484055']
from datafaker.
直接写文件看看
from datafaker.
datafaker rdb mysql+mysqldb://user:password@localhost:3306/demo?charset=utf8 stu 10 --outprint --meta meta.txt --outspliter ',,' >result.dat
我的result.dat内容示例如下
[1, u'rYKLySNFRxZDuGc', u'\u732a\u573a', u'\u9017\u6bd4', 37, 74, 44.31, u'18195210203', u'[email protected]', '192.175.25.85', u'\u9ed1\u9f99\u6c5f\u7701\u6606\u660e\u53bf\u897f\u5cf0\u65b9
u8defx\u5ea7 547960']
[2, u'RKamsnXnjTtWYRql', u'\u6e05\u534e\u4e2d\u5b66', u'\u9017\u6bd4', 65, 33, 43.88, u'13304377714', u'[email protected]', '192.56.224.35', u'\u5b89\u5fbd\u7701\u96ea\u6885\u5e02\u6000\u67d4
u60e0\u5dde\u8857h\u5ea7 189080']
from datafaker.
另外我似乎有发现
datafaker rdb mysql+mysqldb://user:password@localhost:3306/demo?charset=utf8 stu 10 --outprint --meta meta.txt --outspliter ',,' >result.dat
当password长这个样子:
abcdEf$
我密码尾部有个$字符
此时会引起报错
from datafaker.
datafaker file /home out.txt 10 --meta meta.txt
用file命令写文件,应该是汉字
密码有特殊字符,我排查下问题
from datafaker.
好的 datafaker file /home out.txt 10 --meta meta.txt 学习了~ 谢谢 有效了。
from datafaker.
Related Issues (20)
- createtime||datetime||datetime(1,%Y-%m-%d %H:%M) datetime(1) 没有生成当前时间
- 发送kafka 报NoBrokersAvailable: NoBrokersAvailable HOT 1
- datafaker. exceptions. Parse Schemaerror: parse schema error,#年生产计划
- 导出文件每行会多出一行空行
- linux下python3.7运行报错cannot open shared object file: No such file or directory HOT 1
- enum(file://data.txt) 支持指定列
- 怎么处理oracle的date格式
- 【好慢】开了8个worker,写入1万条, 执行好慢 HOT 1
- 目前能支持达梦数据库吗?希望能支持 HOT 1
- order_enum 类型打开超大枚举文件的问题 HOT 3
- 在mac上使用报错,可以修复吗
- 运行日志可以保存下来吗,可以自己定位错误信息
- mac m2 安装Can't pickle <class 'sqlalchemy.orm.session.Session'>: it's not the same object as sqlalchemy.orm.session.Session HOT 2
- Can't pickle <class 'sqlalchemy.orm.session.Session'>: it's not the same object as sqlalchemy.orm.session.Session HOT 1
- 太慢了,生成10条数据还可以,超过1000就不行了 HOT 4
- order_enum重复 HOT 1
- 能否支持从其他列生成相对应的参数,或规则中新增函数类型,调用函数支持传参实现来求值? HOT 2
- 太慢了,是我操作有问题么 HOT 2
- datetime_between类型 生成sql 是 多了一对单引号导致插入数据失败: 例如 ''2021-01-01 00:00:00''
- mysql下处理int数据时,ValueError: empty range for randrange() (11,1, -10)
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from datafaker.