Comments (6)
For some reason we have a lot of these typing issues now which I did not encounter before. What does WorkbenchJ show when you use the 'Database Explorer' and select the 'arm' table? Doing this should show all the columns and their types and im interested what it thinks about your nested types.
ps. why do you prefix it with "index"."data-generator-poc-async" that should not be needed when you are connected with the "data-generator-poc-async" index right?
from sql4es.
Database Explorer shows the following:
system java.lang.Object NO NO NO NO {properties={host={type=string, fields={raw={type=string, index=not_analyzed, ignore_above=10000}}}, sampletime={type=date, format=strict_date_optional_time||epoch_millis}}} 2000 0
"system.host" string(1) NO NO NO NO {type=string, fields={raw={type=string, index=not_analyzed, ignore_above=10000}}} 12 0
"system.sampletime" date NO NO NO NO {type=date, format=strict_date_optional_time||epoch_millis} 91 0
Squirrel succeeds in running the same query semi-successfully - if I do "select system" then I get two columns in the result (system.sampletime and system.host) but system.sampletime only has "Error" on each line. If I do "select system.sampletime, system.host" then both columns are populated correctly.
p.s. the prefix is indeed redundant, it was there because I copied the statement from a Drill query, but it doesn't change the behavior - running the query without the "index" prefix results in the same issue.
from sql4es.
I did some digging using an old dataset with lots of nesting and it seems this issue has to do with the Date type and i guess it is related with the other issue as well. Requesting nested objects that do not have a Date works fine but if there is a date somewhere it breaks. Not sure why it happens though and might take some time to figure it out
from sql4es.
Hi Dan,
I have implemented a fix for this issue which now works on my testset with multiple nested objects. Please use the latest 0.8.2.4 release to test it on your own data and let me know if it works.
from sql4es.
I think it works, in Squirrel I am able to get both nested fields correctly when doing select system (where system is a compound type), however now there is strange behavior which I think may be related to #22 where in Workbench I don't get any results when running select * from :
select count(*) from arm - returns correct number of 2014567 documents
select * from arm - returns 0 rows
When using Drill, the same query returns exactly 10 rows, even though no such limit is specified..
from sql4es.
I commented in the other thread about the issue, and closing this one since this is now resolved.
from sql4es.
Related Issues (20)
- DISTINCT - COUNT Combination Reg. HOT 2
- "having field = value" in select statement can't work correctly HOT 2
- Issue with exposing metadata of aliases
- Memory consumption
- Date issues HOT 3
- Fetch First x ROWS isn't supported ?
- ES 5.4 Error SQL4ES 5.0.0 HOT 1
- Date Time format issue HOT 1
- Support for Elastocsearch 5.x
- first bug
- the second bug
- the last
- Issue with Elasticsearch 5.2.0 HOT 1
- ORDER BY filed of date type is not supported?
- Unable to Connect to Elasticsearch 5.5.3 using JDBC Driver sql4es-0.8.2.4.jar. HOT 1
- ElasticSearch 6.X - Failed test cases
- Not able to connect to elastic versions 5.X.X
- Elasticsearch 6.5.0 - compilation/test failures.
- some field names have no value like uv visits ...?
- order by parse bug
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 sql4es.