Reputation: 15355
"sql like" alternatives for apache hive
I am looking a solution for a distributed database that will support queries similar to sql.
To be more precise it should have a JDBC connector and same or similar to sql syntax.
From googling I found HIVE with hadoop.
What other alternatives do you know of?
Upvotes: 1
Views: 907
Answers (2)
Reputation: 132
The hive thrift server is something you might want to look at. Be aware of the pitfalls though.
https://cwiki.apache.org/confluence/display/Hive/HiveServer
Upvotes: 1
Reputation: 33495
Cloudera Impala is a framework which supports SQL like queries and is compatible with HiveQL..
While Hive has been for some time and oriented for batch processing, Impala is new and is geared for real time processing.
Not exactly sure if JDBC works with Impala.
Upvotes: 2
Related Questions
- QUALIFY equivalent in HIVE / SPARK SQL
- Information on Apache HIVE
- Hadoop with Relational Database
- Hibernate dialect for Hive/SparkSQL?
- Hive alternative for big data query
- What can you do with hadoop that is impossible or very hard to do with Hive?
- Real Time Interactive Queries IN HADOOP
- How close is Hbase/Hive to a major RDBMS?
- realtime querying/aggregating millions of records - hadoop? hbase? cassandra?
- Distributed data aggregations, querying, filtering: any alternative frameworks to Hadoop/Mapreduce? (MR is too slow)