Comments (1)
ActiveData has some aliases for operators; both ne
and neq
are valid and the same: https://github.com/mozilla/ActiveData/blob/master/pyLibrary/queries/expressions.py#L3038
Your original SQL is wrong:
select build.product from tasks where foo != "firefox"
Unlike Python, SQL double quotes are different than single quotes. The double quotes are for declaring variable and table names, while single quotes are for quoting literal strings. The "firefox"
is referring to the "firefox" variable, which does not exist.
Plus, thetasks
table does not exist; it can;t be plural; use task
select build.product from task where foo != 'firefox'
from activedata.
Related Issues (20)
- repo returning limit of 10k results on bulk query HOT 2
- Scanning the coverage column is a problem
- Store bugs fixed by a changeset in the 'repo' table
- Problem with filtering on inner/nested column HOT 3
- No way to retire columns?
- OrangeCount is broken HOT 2
- ~e~ still infecting queries HOT 3
- deep query not working HOT 2
- busted queries are wrong HOT 5
- fix the @skip("still broken") tests
- "union" may be too memory intensive? HOT 1
- Update schema docs:
- Allow column if both in select and groupby clauses
- Treeherder query is broken
- No aggregate results in null
- `moz-fx-dev-ekyle-treeherder`.`treeherder_2d_stage` has stopped updating HOT 7
- ensure first/any/one work on primitive fields
- ensure first/any/one work on nested fields HOT 1
- Travis CI free usage ends Dec 3; mozilla repos should switch to other CI platforms
- Possible improvement for method 'html2unicode'
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 activedata.