Questions tagged [dremel]

Dremel is an ad-hoc query engine developed by Google. Google BigQuery is the external implementation of Google's internal tool Dremel. Use this tag for questions related to Dremel and use the google-bigquery tag for questions about BigQuery.

Dremel is an ad-hoc query engine developed by Google. Google BigQuery is the external implementation of Google's internal tool Dremel.

Dremel was designed for interactive queries and provides excellent response time due to it's tree-based architecture.

References

Related Tags

19 questions
0
votes
1 answer

How does Dremel or its implementation (say Drill) handle large columnar data layout in memory?

I am going through the white paper of Google Dremel. I came to know it converts complex data into columnar data layout. At what location is this data stored? As Drill has no central metadata repository, I assume it must be in-memory. Therefore how…
Dev
  • 13,492
  • 19
  • 81
  • 174
0
votes
2 answers

In google's dremel, what algorithm that top-k query makes use of?

Google's Dremel algorithm supports top-k queries. Could somebody tell me what algorithm that top-k query makes use of?
-1
votes
1 answer

Nested SQL query: how to return one sample from each log

I'm trying to implement a nested query to pull no more than one sample per log, and I think I know how to implement its components separately: Query a set of logs that contain data relevant to my analysis: SELECT runs.object_type as…
vadbut
  • 39
  • 6
-3
votes
1 answer

How can i make this query better ? Is this the correct use of the CASE statement?

Among the students registered for the course "Psychology". what % of them have a GPA > 3? Student: student_id* | student_name | student_gender Course: course_id* | course_name | course_type Student_course_grade: student_id | course_id |…
Joe
  • 1
  • 1
1
2