Provided are techniques for providing and using pivot facets for text mining and search. A metadata field is mapped to a pivot facet. In response to executing a first query, at least a first document and the pivot facet are displayed. In response to selection of the pivot facet, a second query that includes a value of the metadata field is generated, and the second query is executed to locate at least a second document that includes the value of the metadata field.