Comments (4)
Interesting I use textql with tab all the time
Does -dlm=0x09
work on your file?
from textql.
The problem was with the input file. I had to use a different editor to put the tab characters properly. It is working fine now.
[kveeramuthu@trinityqa1-235347 ~]$ textql -source ~/sample_data.tsv -header -dlm=tab -sql "select * from tbl" -verbose=true
Data loaded in: 190.242us
1, kousi, 10
2, umesh, 20
3, don, 30
Queries run in: 247.045us
[kveeramuthu@trinityqa1-235347 ~]$ textql -source ~/sample_data.tsv -header -dlm=0x09 -sql "select sum(value),sum(id),max(name) from tbl" -verbose=true
Data loaded in: 100.992us
60, 6, umesh
Queries run in: 112.564us
[kveeramuthu@trinityqa1-235347 ~]$
from textql.
Glad you were able to figure it out!
In the future, remember you can use whatever character you want for the delimiter, if you want, as long as you know the hex code.
from textql.
Awesome. Thanks.
BTW, love this tool.
from textql.
Related Issues (20)
- Infinite loop generating newlines with semicolon and newline in the query HOT 2
- too many SQL variables
- Cannot spawn a Docker container running as unprivileged user HOT 1
- release a binary on github HOT 1
- Feature request: $50 donation to help add USV (Unicode Separated Values)
- exit-status option?
- Suggestion: Continuous Fuzzing HOT 1
- Quick instructions in text form from video.
- Is it possible to load sqlite extensions?
- Feature request: Add support for outer union
- Semicolon in literal breaks the processing HOT 2
- Trying to sum and divide HOT 3
- /usr/bin/textql: Argument list too long HOT 1
- Release new version with go modules
- Webservice version
- TestCSVInputHasAName fails with Go 1.17
- Magicify() sometimes turnes double quotes into single quotes
- request a new release
- Neither CONCAT nor || are working for concatenating
- no such function: timediff
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 textql.