COLLECTION
Women's Center Archive: University of Virginia
Summary Statistics
Number of Records: 431Year Range: 1954 - 2016
Collection ID: 14
DESCRIPTION
The items in this Collection document cases of reported racial discrimination and violence that appeared in the student newspaper Cavalier Daily from 1954 to at least 2016, including but not limited to events at UVA and in Charlottesville. The inclusion of events outside Charlottesville illuminates the discourse of race carried on in the Cavalier Daily. By including a Collection dedicated to this topic, the creators of this archive hope to facilitate scholarship at the intersection of race and sexual violence.
The items in this Collection document cases of reported racial discrimination and violence that appeared in the student newspaper Cavalier Daily from 1954 to at least 2016, including but not limited to events at UVA and in Charlottesville. The inclusion of events outside Charlottesville illuminates the discourse of race carried on in the Cavalier Daily. By including a Collection dedicated to this topic, the creators of this archive hope to facilitate scholarship at the intersection of race and sexual violence.
Gallery
FILTER
SORT
Title:
Phi Kappa Psi releases statement noting factual inaccuracies in Rolling Stone article account
Date:
December 5, 2014
Title:
Cavalier Daily September 1, 1992 - Casteen Emphasizes New Posts for Women, Report finds Faculty Woes at Darden
Date:
September 1, 1992
Title:
Cavalier Daily Sept 1, 1992 - Gender Issues Prevail After Stripper Incident
Date:
September 1, 1992
Title:
Cavalier Daily September 1, 1992 - Scandals Tarnish Image; Scars Only Temporary
Date:
September 1, 1992
Title:
Cavalier Daily Sept 7, 1992 - Student Assaulted, Beaten During Rugby Road Party
Date:
September 7, 1992
Title:
Cavalier Daily Sept 8, 1992 - Police Continue to Investigate Assault; Police Report Second Assault
Date:
September 8, 1992
Title:
Cavalier Daily Sept 8, 1992 - Third Student Assault Reported; Police Request Radford's Help in Investigation
Date:
September 8, 1992
Title:
Cavalier Daily Sept 9, 1992 - Assault Investigators Find Inconsistencies
Date:
September 9, 1992
Title:
Cavalier Daily Sept 18, 1992 - City Officials, Greeks Discuss Local Policies
Date:
September 18, 1992
Title:
Cavalier Daily Sept 16, 1992 - Drawing Dialogue; Defending the Village; No Excuses
Date:
September 16, 1992
Title:
Council Rejects Input Resolution; Fraternity Members, Officials Study System
Date:
September 16, 1992
Title:
Cavalier Daily Sept 21, 1992 - Willing to be Involved...But Lacking Communication
Date:
September 21, 1992
Title:
Cavalier Daily - Sexual Harassment Awareness Rises; Students Encounter Difficulty Overcoming Sexism
Date:
September 21, 1992
Title:
Cavalier Daily Sept 24, 1992 - Suspect Denied Bond Request; University Employee Abducted
Date:
September 24, 1992
Title:
Cavalier Daily Sept 25, 1992 - Society's "Southern" Response to Violence Not a Solution
Date:
September 25, 1992
Title:
Cavalier Daily Oct 1, 1992 - Beyond Grounds; Attacks Reveal Troubled Relationship
Date:
October 1, 1992
Title:
Cavalier Daily Sept 27, 2005 - UJC Votes to Create Sexual Assault Liaison
Date:
September 27, 2005
Title:
Cavalier Daily Apr 1, 2014 - Someone You Know - Sexual Assault at the University
Date:
April 1, 2013
Title:
Cavalier Daily Apr 26, 2000 - University Confronts Issues of Sexual Assault
Date:
April 26, 2000
Title:
Cavalier Daily Oct 23, 2006 - Looking for a Safe Stance on Sexual Assault? Me Neither.
Date:
October 23, 2006
Title:
Cavalier Daily Oct 23, 2002 - UJC Changes Sexual Assault Board Design, Proceedings
Date:
October 23, 2002
Title:
Cavalier Daily Apr 7, 2006 - Take Back the Night Battles Against Sexual Assault
Date:
April 7, 2006
Title:
Cavalier Daily Jan 16, 2015 - Proposed Bill to Require Campus Police to Report Sexual Assault to Commonwealth Attorney
Date:
January 16, 2015
Title:
Cavalier Daily Sept 19, 2014 - WYNN: Don't Marginalize Survivors of Sexual Assault
Date:
September 19, 2014
Title:
Cavalier Daily Sept 21, 2014 - White House Launches Sexual Assault Prevention Campaign
Date:
September 21, 2014
Title:
Cavalier Daily Feb 26, 2015 - GORMAN: No Scarlet Letter for Sexual Assault
Date:
February 26, 2015
Title:
Cavalier Daily Jan 29, 2015 - Virginia General Assembly Considers Sexual Assault Legislation
Date:
January 29, 2015
Title:
Cavalier Daily Nov 30, 2004 - U.Va. Police Investigate Sexual Assault Case
Date:
November 30, 2004
Title:
Cavalier Daily Feb 25, 2015 - JACKSON: Language About Sexual Assault Matters
Date:
February 25, 2015
Title:
Cavalier Daily Mar 17, 2015 - Community Artist Malena Magnolia Photographs Students for Exhibition About Sexual Assault
Date:
March 17, 2015
Title:
Cavalier Daily Aug 29, 2014 - Anti-sexual Assault Products' Popularity Surges
Date:
August 29, 2014
Title:
Cavalier Daily Oct 3, 1974 - University Crime Rate Ranks Sixth in Nation
Date:
October 3, 1974
Title:
Cavalier Daily Oct 24, 1975 - Crime Increasingly Plagues City, Students
Date:
October 24, 1975
Title:
Cavalier Daily Oct 29, 1975 - Rape Report Fails to Encompass All Aspects
Date:
October 29, 1975
Title:
Cavalier Daily Nov 20, 1975 - Getting Down to the Issues in "Rape City"
Date:
November 20, 1975
Title:
Cavalier Daily Nov 25, 1975 - FBI Statistics Show Rise in University Crime Rate
Date:
November 25, 1975
Title:
Cavalier Daily April 19, 1979 - Attacks Can Occur Even in "Safest" Neighborhoods
Date:
April 19, 1979
Title:
Cavalier Daily Apr 25, 1979 - Convicted Students Receive "Trifling" Punishment
Date:
April 25, 1979
Title:
Cavalier Daily Apr 8, 1993 - UNC Institutes Expulsion Policy for Assaults; BOV Awaits Responses to Sexual Issue
Date:
April 8, 1993
Title:
Cavalier Daily Apr 12, 1993 - Jefferson Society to Face Allegations; Harassment Related to Ban
Date:
April 12, 1993
Title:
Cavalier Daily Apr 13, 1993 - Society Violations Weighed; University Reflects on Conflicting Nature of Founding Father
Date:
April 13, 1993
Title:
Cavalier Daily Apr 15, 1993 - Groups March Against Violence; Casteen Criticized for Response to Scandals.
Date:
April 15, 1993
Title:
Cavalier Daily Apr 19, 1993 - Rapes, Attacks Plague Area in Violence Wave; Allegations Fill Meeting
Date:
April 19, 1993
Title:
Cavalier Daily Apr 20, 1993 - Rape stories yield similar descriptions; Panel to look into Society allegations; Panel discusses effects of gender stereotypes; Professor's dismissal raises questions of relationships
Date:
April 20, 1993
Title:
Cavalier Daily Apr 21, 1993 - Third assault sparks search; Faculty Senate receives protests to relations ban; Local police officers look at measures to beef up security
Date:
April 21, 1993
Title:
Cavalier Daily Apr 22, 1993 - Faculty Senate Backs Tempered Sex Proposal
Date:
April 22, 1993
Title:
Cavalier Daily Apr 23, 1993 - Police Make Progress on Rape Cases; Faculty Body Passes Sex Ban
Date:
April 23, 1993
Title:
Cavalier Daily Apr 1, 2013 - Someone You Know - Sexual Assault at the University
Date:
April 1, 2013
Title:
Cavalier Daily Jan 30, 2007 - Sensible standards for punishing sexual assault
Date:
January 30, 2007
Title:
Cavalier Daily Dec 5, 2014 - Virginia delegates propose revising college safety laws surrounding sexual assault
Date:
December 5, 2014
Title:
Cavalier Daily Nov 15, 2006 - College reps address sexual assault issue
Date:
November 15, 2006
Title:
Cavalier Daily Nov 15, 2006 - Beebe pleads guilty in sexual assault case
Date:
November 15, 2006
Title:
Cavalier Daily Dec 19, 2014 - Board holds special meeting to discuss sexual assault
Date:
December 19, 2014
Title:
Cavalier Daily Nov 21, 2014 - Community confronts sexual assault on Grounds
Date:
November 21, 2014
Title:
Cavalier Daily Nov 25, 2014 - Sexual Assault Resource Agency holds annual award celebration
Date:
November 25, 2014
Title:
Cavalier Daily Apr 14, 2014 - Sexual Assault Leadership Council launches Take Back the Night week
Date:
April 14, 2014
Title:
Cavalier Daily Dec 4, 2014 - University professor drafts sexual assault survivor bill of rights
Date:
December 4, 2014
Title:
Cavalier Daily Apr 1, 2009 - Candlelight vigil raises sexual assault awareness
Date:
April 1, 2009
Title:
Cavalier Daily Feb 9, 2015 - University responds to sexual assault compliance inquiries
Date:
February 9, 2015
Title:
Cavalier Daily Feb 12, 2015 - Sexual assault legislation passes, aids victims, protects college students
Date:
February 12, 2015
Title:
Cavalier Daily June 2, 2015 - Campus sexual assault report, recommendations presented to Governor McAuliffe
Date:
June 2, 2015
Title:
Cavalier Daily July 20, 2000 - Sexual assault reported at St. Anne's school
Date:
July 20, 2000
Title:
Cavalier Daily Nov 25, 2002 - Police link recent sexual assault to past crimes
Date:
November 25, 2002
Title:
Cavalier Daily Apr 17, 2000 - University student reports sexual assault off Grounds
Date:
April 17, 2000
Title:
Cavalier Daily Mar 26, 2013 - University lab develops faster ID procedures for sexual assault cases
Date:
March 26, 2013
Title:
Cavalier Daily Apr 2, 2015 - Virginia Policy Review discusses nationwide sexual assault policies
Date:
April 2, 2015
Title:
Cavalier Daily Nov 7, 2001 - Plum pleads guilty in two sexual assault cases
Date:
November 7, 2001
Title:
Cavalier Daily Nov 17, 2014 - Charlottesville bars discuss how to combat sexual assault
Date:
November 17, 2014
Title:
Cavalier Daily Sept 9, 2005 - City man cleared in sexual assault investigation
Date:
September 9, 2005
Title:
Cavalier Daily Feb 2, 2001 - NIJ grant to fund DNA research for sexual assault cases
Date:
February 2, 2001
Title:
2015/01/20 - University hires law firms to review sexual assault policies
Date:
January 20, 2015
Title:
Cavalier Daily Oct 17, 2007 - U.Va. student escapes attempted sexual assault
Date:
October 17, 2007
Title:
Cavalier Daily Mar 11, 2003 - Police seek suspect in recent sexual assault case
Date:
March 11, 2003
Title:
Cavalier Daily Oct 4 2012 - Charlottesville Police arrest sexual assault suspect
Date:
October 4, 2012
Title:
Cavalier Daily Nov 18, 2014 - Police respond to weekend sexual assault
Date:
November 18, 2014
Title:
Cavalier Daily Nov 19, 2015 - â€‹A new platform for survivors to report sexual assault
Date:
November 19, 2015
Title:
Cavalier Daily Dec 2, 2004 - Student groups offer feedback on U.Va. sexual assault policy
Date:
December 2, 2004
Title:
Cavalier Daily Sept 21, 2015 - Campus climate survey shows nearly one in four women experiences sexual assault, misconduct at U.Va.
Date:
September 21, 2015
Title:
Cavalier Daily Apr 17, 2014 - SMART resolution targets sexual assault at U.Va.
Date:
April 17, 2014
Title:
Cavalier Daily Sept 17, 2014 - Student Council talks sexual assault prevention, Graham
Date:
September 17, 2014
Title:
Cavalier Daily Sept 22, 2014 - â€‹Charlottesville group helps organize national project to support sexual assault survivors
Date:
September 22, 2014
Title:
Cavalier Daily Apr 8, 2004 - University student reports attempted sexual assault
Date:
April 8, 2004
Title:
Cavalier Daily Apr 1, 2015 - Board hears report on University response to sexual assault allegations
Date:
April 1, 2015
Title:
Cavalier Daily Sept 30, 2002 - Police look into second sexual assault incident
Date:
September 30, 2002
Title:
Cavalier Daily Oct 13, 2014 - Virginia sexual assault on campus task force holds first meeting
Date:
October 13, 2014
Title:
Cavalier Daily June 10, 2015 - Jesse Matthew pleads guilty in Fairfax sexual assault case
Date:
June 10, 2015
Title:
Cavalier Daily Sept 26, 2011 - Former University student examines possible surge in sexual assaults
Date:
September 26, 2011
Title:
Cavalier Daily Feb 9, 2000 - Competition hinders sexual assault groups' mission
Date:
February 9, 2000
Title:
Cavalier Daily Sept 2, 2015 - Navigating the red zone: sexual assault spikes in the first months of college
Date:
September 2, 2015
Title:
Cavalier Daily Sept 22, 2015 - Takeaways from the campus climate survey and OCR review
Date:
September 22, 2015
Title:
Cavalier Daily Feb 19, 2014 - Students rally for harsher punishments for sexual crimes
Date:
February 19, 2014
Title:
Cavalier Daily Sept 10, 2014 -Sexual misconduct reporting policy remains ambiguous
Date:
September 10, 2014
Title:
Cavalier Daily Oct 27, 2014 - StudCo president, Sexual Violence Prevention Council chair invited to White House
Date:
October 27, 2014
Title:
Cavalier Daily Nov 22, 2004 - Protesting sexual assault and enforced silence
Date:
November 22, 2004
Title:
Cavalier Daily Dec 22, 2014 - Student group crafts sexual assault prevention policy proposals for Board of Visitors
Date:
December 22, 2014
Title:
Cavalier Daily Jan 27, 2016 - Sexual assault report turned over to Charlottesville Police
Date:
January 27, 2016
Title:
Cavalier Daily Nov 30, 2014 -Student sexual assault survivors speak out
Date:
November 30, 2014
Title:
2014/01/28 - Handprint Project seeks to reduce bid night sexual assaults
Date:
January 28, 2014
Title:
Cavalier Daily Apr 15, 2014 -Take Back the Night hosts Sexual Misconduct Board mock trial
Date:
April 15, 2014
Title:
Cavalier Daily Nov 20, 2014 - University proposes updated sexual misconduct policy
Date:
November 20, 2014
Title:
Cavalier Daily March 3, 2015 - Virginia legislature passes bills to address campus sexual assault
Date:
March 3, 2015
Title:
Cavalier Daily Apr 14, 2016 - Take Back the Night marches across Grounds for sexual assault awareness
Date:
April 14, 2016
Title:
Cavalier Daily Feb 10, 2014 - U.Va. kicks off national conference on sexual misconduct
Date:
February 10, 2014
Title:
2014/08/31 - University leaders meet to discuss sexual misconduct prevention
Date:
August 31, 2014
Title:
Cavalier Daily Apr 19, 2016 - In 2016, collegiate clubs say coeducation could cause sexual assault
Date:
April 19, 2016
Title:
Cavalier Daily Nov 10, 2014 - â€‹UJC revamps sexual misconduct subcommittee
Date:
November 10, 2014
Title:
Cavalier Daily Dec 3, 2014 - Scholars, activists discuss campus sexual misconduct policy
Date:
December 3, 2014
Title:
2014/12/05 - Rolling Stone releases statement retracting part of sexual assault article
Date:
December 5, 2014
Title:
2015/03/03 - Warner, U.S. Senators introduce far-reaching Campus Accountability and Safety Act
Date:
March 3, 2015
Title:
2012/12/04 - National campaign spotlights University's sexual assault victims
Date:
December 4, 2012
Title:
2014/11/10 - Princeton responds to DOE investigation of sexual misconduct policies
Date:
November 10, 2014
Title:
2014/11/22 - Students host Slut Walk to protest rape culture, sexual assault
Date:
November 22, 2014
Title:
2015/09/21 - Lady Gaga's new video focuses on sexual assault on college campuses
Date:
September 21, 2015


ASP.NET applications in C# or Visual Basic programmer are easily built using the .NET Class. We recommend that you build application-specific classes that you can call from your ASP.NET pages. So instead of trying to call lsInit, lsLoad, lsExec, etc. from your ASP.NET page, instead create a .NET class that performs a higher-level reasoning process like 'determine best shipping method', 'recommend restaurant' or 'plan schedule'.
There are examples in samples/internet/asp.net.
JSP pages and Java Servlets can readily call Java objects. We recommend you use the Java to build custom classes that call the Java LogicServer Class to perform reasoning functions.
There are examples in samples/internet/jsp and samples/internet/servlets.
To learn more about building Servlets and using JSP see The Java Web Services Tutorial.
Copyright ©1987-2011 Amzi! inc. All Rights Reserved. Amzi! is a registered trademark and Logic Server is a trademark of Amzi! inc.


LaVine is slamming dunk at NBA All-Star Game 2016.
Here's a time line of Zach LaVine's life:
1995 - LaVine was born in Renton, Washington, to athletic parents.
2012 - LaVine verbally committed to attending UCLA and playing for coach Ben Howland for the 2013 season.
2013 - After a strong start to 2013–14 as the team's sixth man, featuring an impressive display of outside shooting and explosive dunks, the former point guard LaVine evoked memories of former Bruin Russell Westbrook's UCLA
beginnings.
2014 - He endured a shooting slump where he made just 7 of 36 shots from the field. He averaged 9.4 points per game made were the second most by a freshman in the school's history.
2014 - LaVine was selected by the Minnesota Timberwolves with the 13th overall pick in the 2014 NBA draft and signed his rookie scale contract on July 8, 2014.
2015 - the Timberwolves exercised their third-year team option on LaVine's rookie scale contract, extending the contract through the 2016–17 season.
2016 - LaVine scored 30 points for Team USA in the Rising Stars Challenge to capture MVP honors. He also became the fourth player ever to win consecutive Slam Dunk Contests.
"Me and him are now like best friends, me and Stuff."
If you have time, you should read more about this incredible human being on his Wikipedia entry.


House Organizer
Home
Are you a hoarder?
About Us
Contact
Take the quiz below to find out how badly you need our services.


Home
Project Governance
Data Module
Dashboard
Admin
Logout
Welcome Suprit Patra
Show Role
Regular User
Doc
Line Manger
Executive Member
Important announcement about governance portal goes here...
|
Important announcement goes here...
|
Important announcement goes here...
|
Important announcement about governance portal goes here...
Tasks Assigned By Me
My Activities
My Alerts
ID
Tasks I Assigned
Assigned to
Status
Due Date
Assigned Date
12
Complete documentation
A.Axler
Need Clarity
15-05-2011
15-06-2011
67
Complete pending coder queries
A.Axler
Need Clarity
10-05-2011
15-06-2011
32
Submit Sampling data
A.Menna
Open
18-04-2011
15-06-2011
15
Submit 100% build specs
D.Milot
Open
12-04-2011
15-06-2011
28
Update Peer Review Sheet
R.Bolton
Open
17-03-2011
15-06-2011
30
Submit 100% build specs
R.Bolton
Open
15-05-2011
15-06-2011
35
Submit Sampling data
W.O'Mahony
Open
10-05-2011
15-06-2011
Create New Task
View All
ID
My Activities
Assigned by
Status
Priority
Due Date
12
Complete documentation
A.Axler
Need Clarity
High
15-05-2011
67
Complete pending coder queries
A.Axler
Need Clarity
High
10-05-2011
32
Submit Sampling data
A.Menna
Open
Low
18-04-2011
15
Submit 100% build specs
D.Milot
Open
Low
12-04-2011
28
Update Peer Review Sheet
R.Bolton
Open
Low
17-03-2011
30
Submit 100% build specs
R.Bolton
Open
Low
15-05-2011
35
Submit Sampling data
W.O'Mahony
Open
Low
10-05-2011
View All
ID
My Activities
Status
Assigned Date
12
Complete documentation
Need Clarity
15-05-2011
67
Complete pending coder queries
Need Clarity
10-05-2011
32
Submit Sampling data
Open
18-04-2011
15
Submit 100% build specs
Open
12-04-2011
28
Update Peer Review Sheet
Open
17-03-2011
30
Submit 100% build specs
Open
15-05-2011
35
Submit Sampling data
Open
10-05-2011
View All
My Metrics
My Projects
Study ID
Therapeutic Area
Line Manger
DOC
1275148SCD2001
Immunology
Anitha Chavan
Pooja Amarnath
26866138CAN2007
Immunology
Anitha Chavan
Pooja Amarnath
26866138LYM2033
Oncology
David Ignatius
Rajeshwari Kotekar
26866138LYM3002
Oncology
Santhosh V
Purba Bhattacharjee
26866138MMY2043E
Immunology
Debreena Chatterjee
Vikas Agrawal
26866138MMY3002E
Cardiovascular
Santhosh V
Avila Theresa Anitha
26866138MMY3021
Neurology
Deepu Joseph
Nimisha Nigam
View All


Aggregate and Aggregate Statistical
Aggregate Functions
The following table lists the aggregate functions that you can use in Drill queries.
| Function | Argument Type | Return Type |
|---|---|---|
| ANY_VALUE(expression) | BIT, INT, BIGINT, FLOAT4, FLOAT8, DATE, TIMESTAMP, TIME, VARCHAR, VARBINARY, LIST, MAP, INTERVAL, INTERVALDAY, INTERVALYEAR, VARDECIMAL | Same as argument type |
| AVG(expression) | SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL | DECIMAL for DECIMAL argument, DOUBLE for all other arguments |
| BOOL_AND(expression), BOOL_OR(expression) | BIT | BIT |
| BIT_AND(expression), BIT_OR(expression) | INT, BIGINT | |
| COUNT(*) | - | BIGINT |
| COUNT([DISTINCT] expression) | any | BIGINT |
| MAX(expression), MIN(expression) | BINARY, DECIMAL, VARCHAR, DATE, TIME, or TIMESTAMP | Same as argument type |
| SUM(expression) | SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL, INTERVAL | DECIMAL for DECIMAL argument, BIGINT for any integer-type argument (including BIGINT), DOUBLE for floating-point arguments |
- Drill 1.14 and later supports the ANY_VALUE function.
- Starting in Drill 1.14, the DECIMAL data type is enabled by default.
- AVG, COUNT, MIN, MAX, and SUM accept ALL and DISTINCT keywords. The default is ALL.
- The aggregate function examples use the
cp
storage plugin to access theemployee.json
file installed with Drill. By default, JSON reads numbers as double-precision floating point numbers. These examples assume that you are using the default option all_text_mode set to false.
ANY_VALUE
Supported in Drill 1.14 and later. Returns one of the values of value across all input values. This function is NOT specified in the SQL standard.
ANY_VALUE Syntax
ANY_VALUE([ ALL | DISTINCT ] value)
ANY_VALUE Examples
SELECT ANY_VALUE(employee_id) AS anyemp FROM cp.`employee.json`;
|--------|
| anyemp |
|--------|
| 1156 |
|--------|
SELECT ANY_VALUE(ALL employee_id) AS anyemp FROM cp.`employee.json`;
|--------|
| anyemp |
|--------|
| 1156 |
|--------|
SELECT ANY_VALUE(DISTINCT employee_id) AS anyemp FROM cp.`employee.json`;
|--------|
| anyemp |
|--------|
| 1156 |
|--------|
SELECT ANY_VALUE(employee_id) as anyemp, salary as empsal FROM cp.`employee.json` GROUP BY salary;
|--------|---------|
| anyemp | empsal |
|--------|---------|
| 1155 | 20.0 |
| 197 | 3700.0 |
| 1115 | 4200.0 |
| 589 | 4300.0 |
| 403 | 4400.0 |
| 204 | 4500.0 |
...
SELECT ANY_VALUE(employee_id) as anyemp FROM cp.`employee.json` GROUP BY salary ORDER BY anyemp;
|--------|
| anyemp |
|--------|
| 1 |
| 4 |
| 6 |
| 8 |
| 10 |
| 13 |
...
AVG
Returns the average of a numerical expression.
AVG Syntax
AVG([ALL | DISTINCT] expression)
AVG Examples
ALTER SESSION SET `store.json.all_text_mode` = false;
|------|-----------------------------------|
| ok | summary |
|------|-----------------------------------|
| true | store.json.all_text_mode updated. |
|------|-----------------------------------|
1 row selected (0.073 seconds)
Take a look at the salaries of employees having IDs 1139, 1140, and 1141. These are the salaries that subsequent examples will average and sum.
SELECT * FROM cp.`employee.json` WHERE employee_id IN (1139, 1140, 1141);
|-------------|-----------------|------------|-----------|-------------|-------------------------|----------|---------------|------------|-----------------------|------------|---------------|-----------------|----------------|--------|----------------------|
| employee_id | full_name | first_name | last_name | position_id | position_title | store_id | department_id | birth_date | hire_date | salary | supervisor_id | education_level | marital_status | gender | management_role |
|-------------|-----------------|------------|-----------|-------------|-------------------------|----------|---------------|------------|-----------------------|------------|---------------|-----------------|----------------|--------|----------------------|
| 1139 | Jeanette Belsey | Jeanette | Belsey | 12 | Store Assistant Manager | 18 | 11 | 1972-05-12 | 1998-01-01 00:00:00.0 | 10000.0000 | 17 | Graduate Degree | S | M | Store Management |
| 1140 | Mona Jaramillo | Mona | Jaramillo | 13 | Store Shift Supervisor | 18 | 11 | 1961-09-24 | 1998-01-01 00:00:00.0 | 8900.0000 | 1139 | Partial College | S | M | Store Management |
| 1141 | James Compagno | James | Compagno | 15 | Store Permanent Checker | 18 | 15 | 1914-02-02 | 1998-01-01 00:00:00.0 | 6400.0000 | 1139 | Graduate Degree | S | M | Store Full Time Staf |
|-------------|-----------------|------------|-----------|-------------|-------------------------|----------|---------------|------------|-----------------------|------------|---------------|-----------------|----------------|--------|----------------------|
3 rows selected (0.284 seconds)
SELECT AVG(salary) FROM cp.`employee.json` WHERE employee_id IN (1139, 1140, 1141);
|-------------------|
| EXPR$0 |
|-------------------|
| 8433.333333333334 |
|-------------------|
1 row selected (0.208 seconds)
SELECT AVG(ALL salary) FROM cp.`employee.json` WHERE employee_id IN (1139, 1140, 1141);
|-------------------|
| EXPR$0 |
|-------------------|
| 8433.333333333334 |
|-------------------|
1 row selected (0.17 seconds)
SELECT AVG(DISTINCT salary) FROM cp.`employee.json`;
|--------------------|
| EXPR$0 |
|--------------------|
| 12773.333333333334 |
|--------------------|
1 row selected (0.384 seconds)
SELECT education_level, AVG(salary) FROM cp.`employee.json` GROUP BY education_level;
|---------------------|--------------------|
| education_level | EXPR$1 |
|---------------------|--------------------|
| Graduate Degree | 4392.823529411765 |
| Bachelors Degree | 4492.404181184669 |
| Partial College | 4047.1180555555557 |
| High School Degree | 3516.1565836298932 |
| Partial High School | 3511.0852713178297 |
|---------------------|--------------------|
5 rows selected (0.495 seconds)
BOOL_AND and BOOL_OR
Returns the result of a logical AND (resp. OR) over the specified expression.
BOOL_AND and BOOL_OR Syntax
BOOL_AND(expression)
BOOL_OR(expression)
BOOL_AND and BOOL_OR Examples
SELECT BOOL_AND(last_name = 'Spence') FROM cp.`employee.json`;
|--------|
| EXPR$0 |
|--------|
| false |
|--------|
SELECT BOOL_OR(last_name = 'Spence') FROM cp.`employee.json`;
|--------|
| EXPR$0 |
|--------|
| true |
|--------|
BOOL_AND and BOOL_OR Usage Notes
- EVERY is nearly an alias for BOOL_AND but returns a TINYINT rather than a BIT.
BIT_AND and BIT_OR
Returns the result of a bitwise AND (resp. OR) over the specified expression.
BIT_AND and BIT_OR Syntax
BIT_AND(expression)
BIT_OR(expression)
BIT_AND and BIT_OR Examples
SELECT BIT_AND(position_id) FROM cp.`employee.json`;
|--------|
| EXPR$0 |
|--------|
| 0 |
|--------|
SELECT BIT_OR(position_id) FROM cp.`employee.json`;
|--------|
| EXPR$0 |
|--------|
| 31 |
|--------|
COUNT
Returns the number of rows that match the given criteria.
COUNT Syntax
SELECT COUNT([ALL | DISTINCT] expression) FROM . . .
SELECT COUNT(*) FROM . . .
- expression
Returns the number of values of the specified expression. - DISTINCT expression
Returns the number of distinct values in the expression. - ALL expression
Returns the number of values of the specified expression. -
- (asterisk) Returns the number of records in the table.
COUNT Examples
SELECT COUNT(DISTINCT salary) FROM cp.`employee.json`;
|--------|
| EXPR$0 |
|--------|
| 48 |
|--------|
1 row selected (0.159 seconds)
SELECT COUNT(ALL salary) FROM cp.`employee.json`;
|--------|
| EXPR$0 |
|--------|
| 1155 |
|--------|
1 row selected (0.106 seconds)
SELECT COUNT(salary) FROM cp.`employee.json`;
|--------|
| EXPR$0 |
|--------|
| 1155 |
|--------|
1 row selected (0.102 seconds)
SELECT COUNT(*) FROM cp.`employee.json`;
|--------|
| EXPR$0 |
|--------|
| 1155 |
|--------|
1 row selected (0.174 seconds)
MIN and MAX
These functions return the smallest and largest values of the selected expressions, respectively.
MIN and MAX Syntax
MIN(expression)
MAX(expression)
MIN and MAX Examples
SELECT MIN(salary) FROM cp.`employee.json`;
|--------|
| EXPR$0 |
|--------|
| 20.0 |
|--------|
1 row selected (0.138 seconds)
SELECT MAX(salary) FROM cp.`employee.json`;
|---------|
| EXPR$0 |
|---------|
| 80000.0 |
|---------|
1 row selected (0.139 seconds)
Use a correlated subquery to find the names and salaries of the lowest paid employees:
SELECT full_name, SALARY FROM cp.`employee.json` WHERE salary = (SELECT MIN(salary) FROM cp.`employee.json`);
|-----------------|--------|
| full_name | SALARY |
|-----------------|--------|
| Leopoldo Renfro | 20.0 |
| Donna Brockett | 20.0 |
| Laurie Anderson | 20.0 |
. . .
SUM
Returns the sum of a numerical expresion.
SUM syntax
SUM([DISTINCT | ALL] expression)
Examples
SELECT SUM(ALL salary) FROM cp.`employee.json`;
|-----------|
| EXPR$0 |
|-----------|
| 4642640.0 |
|-----------|
1 row selected (0.123 seconds)
SELECT SUM(DISTINCT salary) FROM cp.`employee.json`;
|----------|
| EXPR$0 |
|----------|
| 613120.0 |
|----------|
1 row selected (0.309 seconds)
SELECT SUM(salary) FROM cp.`employee.json` WHERE employee_id IN (1139, 1140, 1141);
|---------|
| EXPR$0 |
|---------|
| 25300.0 |
|---------|
1 row selected (1.995 seconds)
Aggregate Statistical Functions
The following table lists the aggregate statistical functions that you can use in Drill queries.
| Function | Argument Type | Return Type |
|---|---|---|
| APPROX_COUNT_DUPS(expression) | any | BIGINT |
| STDDEV(expression) | SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL | DECIMAL for DECIMAL arguments, otherwise DOUBLE |
| STDDEV_POP(expression) | SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL | DECIMAL for DECIMAL arguments, otherwise DOUBLE |
| VARIANCE(expression) | SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL | DECIMAL for DECIMAL arguments, otherwise DOUBLE |
| VAR_POP(expression) | SMALLINT, INTEGER, BIGINT, FLOAT, DOUBLE, DECIMAL | DECIMAL for DECIMAL arguments, otherwise DOUBLE |
APPROX_COUNT_DUPS
Returns an approximate count of the values that are duplicates (not unique).
APPROX_COUNT_DUPS Syntax
APPROX_COUNT_DUPS( expression )
APPROX_COUNT_DUPS Examples
select
COUNT(*),
APPROX_COUNT_DUPS(e1.employee_id),
APPROX_COUNT_DUPS(e1.gender)
FROM cp.`employee.json` e1
|--------|--------|--------|
| EXPR$0 | EXPR$1 | EXPR$2 |
| ------ | ------ | ------ |
| 1155 | 0 | 1153 |
|--------|--------|--------|
Use COUNT - APPROX_COUNT_DUPS to approximate a distinct count.
select
COUNT(*),
COUNT(salary) - APPROX_COUNT_DUPS(salary),
COUNT(distinct salary)
from cp.`employee.json`;
|--------|--------|--------|
| EXPR$0 | EXPR$1 | EXPR$2 |
|--------|--------|--------|
| 1155 | 48 | 48 |
|--------|--------|--------|
APPROX_COUNT_DUPS Usage Notes
The underlying Bloom filter is a probabilistic data structure that may return a false positive when an element is tested for duplication. Consequently, the approximate count returned overestimates the true duplicate count. In return for this inaccuracy, Bloom filters are highly space- and time-efficient at large scales with the specifics determined by the parameters of the filter (see below).
Configuration options
Note
The APPROX_COUNT_DUPS function is used internally by Drill when it computes table statistics. As a result, setting configuration options that affect it in the global configuration scope will affect the computation of table statistics accordingly.
- exec.statistics.ndv_extrapolation_bf_elements
- exec.statistics.ndv_extrapolation_bf_fpprobability
STDDEV
Returns the sample standard deviation.
STDDEV Syntax
STDDEV(expression)
STDDEV Examples
SELECT STDDEV(salary) from cp.`employee.json`;
|-------------------|
| EXPR$0 |
|-------------------|
| 5371.847873988941 |
|-------------------|
STDDEV Usage Notes
- Aliases: STDDEV_SAMP
STDDEV_POP
Returns the estimate of the population standard deviation obtained by applying Bessel’s correction to the sample standard deviation.
STDDEV_POP Syntax
STDDEV_POP(expression)
STDDEV_POP Examples
SELECT STDDEV_POP(salary) from cp.`employee.json`;
|-------------------|
| EXPR$0 |
|-------------------|
| 5369.521895151171 |
|-------------------|
VARIANCE
Returns the sample variance.
VARIANCE Syntax
VARIANCE(expression)
VARIANCE Examples
SELECT VARIANCE(salary) from cp.`employee.json`;
|--------------------|
| EXPR$0 |
|--------------------|
| 28856749.581279505 |
|--------------------|
VARIANCE Usage Notes
- Aliases: VAR_SAMP
VAR_POP
Returns the estimate of the population variance obtained by applying Bessel’s correction to the sample variance.
VAR_POP Syntax
VAR_POP(expression)
VAR_POP Examples
SELECT VAR_POP(salary) from cp.`employee.json`;
|--------------------|
| EXPR$0 |
|--------------------|
| 28831765.382507823 |
|--------------------|


Away
done
{{zone.awayArmDelay!==null? zone.awayArmDelay : "-"}}
{{zone.awayAlertDelay!==null? zone.awayAlertDelay : "-"}}
Stay
done
{{zone.stayArmDelay!==null ? zone.stayArmDelay : "-"}}
{{zone.stayAlertDelay!==null ? zone.stayAlertDelay : "-"}}
Disarmed
done
{{zone.disarmedDelay!==null ? "0" : "-"}}
{{zone.disarmedDelay!==null ? zone.disarmedDelay : "-"}}


A d3.js visualization of Loïc Rémy's shots throughout the 2013-14 season. The animation is a bit gratuitous but fun.
The dots appear in chronological order. Hover over a datapoint to find more information about each shot.
Code are available here . Please get in touch via twitter if you have any feedback - @jalapic