VMware vFabric SQLFire is an in-memory distributed SQL database.
Questions tagged [sqlfire]
12 questions
3
votes
2 answers
SQL support cache with fallback to a database
Is there any product which can be queries using JDBC (normal SQL), it sees whether all the tables in the query are in CACHED tables, and use the cache, otherwise fallback to the back-end database.
I am aware of two products: Oracle In Memory…
Amir Pashazadeh
- 7,170
- 3
- 39
- 69
2
votes
2 answers
Using sub-queries in SQL to find max(count())
I am using a program called SQLfire to code and I'm not entirely sure what version we are using but I'm told it needs to work with SQL Server 2008.
Here is what I'm trying to do:
select CustomerNum, max(count(CustomerNum))
from Rentals
group by…
Kuro
- 27
- 1
- 1
- 5
2
votes
2 answers
Outputting Multiple Columns from one Table SQL?
This is for my studies, so I would prefer if you guys could give hints opposed to answers, I don't mind either though. :)
The following link is my data in a SQLFiddle: http://sqlfiddle.com/#!2/d7373
CREATE TABLE Movies
(`MovieID` int, `Title`…
user1330649
- 79
- 5
1
vote
3 answers
Why won't this statement work? SQL
I am using SQLFire. I am doing an assignment and when beginning the assignment I came across that I couldn't return a particular value. See this SQL Fiddle, it contains the EXACT data in the table that I am using in my assignment and it contains the…
user1330649
- 79
- 5
1
vote
2 answers
Selecting values based on other values SQL?
I wasn't sure what to title this question, so I apologize if the title is misleading.
I have two columns in a table MovieID and Format (I have more, but these are the ones i am focusing on.
There are two types of values in the 'Format' column: 'DVD'…
user1330649
- 79
- 5
0
votes
1 answer
GemfireXD RowLoader is not working, connection not being to established to external database
I am working on JDBCRowLoader.. I followed all the instructions, running below attach_loader.
call sys.attach_loader('app', 'cust', 'com.mohan.coe.JDBCRowLoader', '|url=jdbc:oracle:thin:@pivhdsne:1521/xe|query-string=select * from system.cust where…
Madhu Mohan Kommu
- 335
- 2
- 13
0
votes
2 answers
Finding and updating a value
I have two tables; Albums and Loans. I have a BorrowerId = RS96FM in the table loans that has lost its content and therefore I want to update the ShelfNumber in the the albums to 0. However I do not know how to go about this as I first have to find…
user2704085
- 21
- 1
- 4
0
votes
2 answers
SQL Column duplicates matching different values
I have a table in which i am trying to show the different years in which something was released. i have:
Name Releasedate Releasedate
Item 1 2001 2001
Item 1 2001 2001
Item 1 2001 2001
and the type of thing i want…
user2775426
- 1
- 1
0
votes
1 answer
Applying multiple conditions SQL?
I have an assignment that I am having trouble with, since this is for my studies I would appreciate it if you didn't give me the answer straight up, but instead gave me clues (I don't want to cheat).
I have three tables: Movies, Stars and ActsIn. I…
user1330649
- 79
- 5
0
votes
1 answer
Number of Occurrences above a certain number SQL
I need to find how many times each value occurs, although I need to only display the values that occur 4 or more times. I know how to find the number of times a value occurs, but I don't know the second half. Here is an example of my data.
id |…
user1330649
- 79
- 5
0
votes
1 answer
Integrating SQLFire in Maven
I'm trying to integrate SQLFire in a Maven project. What I specifically would like to have is the SQLFire thin client.
While searching the web I found the following blog:…
Ika
- 1,456
- 1
- 15
- 24
0
votes
1 answer
Timeline data- store solution
I'm facing a funny problem: I have to display an aggregated feed of Facebook, Foursquare and Twitter for my users and I don't know what solution to use. A lot of batches are running in parallel, and there are many updates in the activity streams.
I…
Vincent Devillers
- 1,628
- 1
- 11
- 17