Comments (9)
请问使用的oracle版本是?
from quicksql.
按照README中的操作说明,把mysql 、oracle表元数据导入到qsql中,oracle表执行了
'SELECT * FROM USER LIMIT 1'
'SELECT * FROM USER LIMIT 10 OFFSET 10'
'SELECT * FROM USER OFFSET 10 ROWS FETCH NEXT 10 ROWS ONLY '
均报错ORA-00933 SQL 命令未正确结束
由于在公司内网测试,网络限制,异常堆栈不能提供,抱歉。
使用的是
https://github.com/Qihoo360/Quicksql/releases/tag/release-0.6
oracle jdk 1.8.0_151
from quicksql.
请问使用的oracle版本是?
11.2.0.1.0
from quicksql.
感谢反馈,由于Oracle不同版本分页查询的语法不太一样,所以还未确定最终的方言转换方式。这个问题会在下一个迭代中优先进行解决。再次表示感谢~
from quicksql.
感谢反馈,由于Oracle不同版本分页查询的语法不太一样,所以还未确定最终的方言转换方式。这个问题会在下一个迭代中优先进行解决。再次表示感谢~
你好,请问qsql推荐的oracle版本是多少?
from quicksql.
理论上希望用户接入的Oracle版本都>= 12c,这样所有的分页查询都是OFFSET ROWS FETCH ROW,可以由统一的QSQL语法LIMIT OFFSET转换过去,但这样对于已有的老版本兼容不好,老版本的WHERE ROWNUM目前的使用范围也很广。如果不介意的话我将ISSUE名字改为英文,作为下一个迭代的需求。
from quicksql.
理论上希望用户接入的Oracle版本都>= 12c,这样所有的分页查询都是OFFSET ROWS FETCH ROW,可以由统一的QSQL语法LIMIT OFFSET转换过去,但这样对于已有的老版本兼容不好,老版本的WHERE ROWNUM目前的使用范围也很广。如果不介意的话我将ISSUE名字改为英文,作为下一个迭代的需求。
好的 ,感谢您耐心的答复,谢谢
from quicksql.
Oracle分页语法已兼容
from quicksql.
我使用的是0.7.0,oracle还是有类似的问题,java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
from quicksql.
Related Issues (20)
- quickSQL往spark上提交的问题 HOT 1
- 是否可以将com.oracle:ojdbc6:11.2.0.3更新为com.oracle.database.jdbc:ojdbc6:11.2.0.4?
- IDEA里运行CsvScanExample测试时使用Spark Local模式、LZ4压缩报错 HOT 3
- 在linux部署项目后,使用./quicksql.sh -e "SELECT 1" --runner spark出错:.NoSuchMethodError: org.apache.commons.lang3.ObjectUtils.anyNotNull HOT 4
- Error in document content
- 求大神帮忙看个报错ERROR|compiler.err.prob.found.req HOT 1
- When locating the database, we need to associate the datatype HOT 1
- quicksql导入spark、flink数据异常
- 请问下用calcite parse 测试时获取SqlJoin时为什么报错
- UnsupportedOperationException when running CsvScanExample locally
- 导入数据源以后是否支持实时更新schema信息
- Explain sql execute error
- 当我调试example时候,报错 java.lang.NoSuchMethodError: com.fasterxml.jackson.databind.JsonMappingException
- [BUG] testParseSingleBdNameAndTableNameWithError in tableNameCollectorTest is not as expected
- java.io.FileNotFoundException
- unknown type -1
- 程序包org.elasticsearch.spark.sql.api.java不存在
- The server failed to issue an HTTP response, retrying
- 未来会支持doris、hudi这样的数据库吗?
- 果然,永远不会更新了。 HOT 3
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 quicksql.