Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Importing the Beeradvocate dataset
//Import BeerAdvocate
//Michael's version - THIS IS THE VERSION THAT WORKS
//This covers 1 iteration - you need 15 to import the total dataset - see below...
//put all the indexes in place
create index on :Beer(name);
create index on :Style(name);
create index on :Brewery(id);
create index on :Profile(name);
create constraint on (b:Beer) assert b.id is unique;
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add an Anonymous profile
merge (p:Profile {name:"Anonymous"});
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// generate the META-graph
// run this after the FIRST iteration of the queries above
// DO NOT run after the last iteration - it would be very slow and not add anything!
MATCH (a)-[r]->(b)
WITH labels(a) AS a_labels,type(r) AS rel_type,labels(b) AS b_labels
UNWIND a_labels as l
UNWIND b_labels as l2
MERGE (a:Meta_Node {name:l})
MERGE (b:Meta_Node {name:l2})
MERGE (a)-[:META_RELATIONSHIP {name:rel_type}]->(b)
RETURN distinct l as first_node, rel_type as connected_by, l2 as second_node
//Import BeerAdvocate
//Rix Attempt - DID NOT WORK
//put all the indexes in place
create index on :Beer(name);
create index on :Style(name);
create index on :Brewery(id);
create index on :Profile(name);
//import beers, breweries, styles
using periodic commit
load csv with headers
from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv
fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {name: csv.beer_name, ABV: csv.beer_ABV, id: toInt(csv.beer_beerId)})
merge (b)-[:HAS_STYLE]-(s:Style {name: csv.beer_style})
merge (b)<-[:BREWS]-(br:Brewery {id: toInt(csv.beer_brewerId)});
//import beers, breweries, styles
using periodic commit
load csv with headers
//from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/sample.csv" as csv
from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv
fieldterminator ';'
with csv
where csv.beer_ABV is null
merge (b:Beer {name: csv.beer_name, id: toInt(csv.beer_beerId)})
merge (b)-[:HAS_STYLE]-(s:Style {name: csv.beer_style})
merge (b)<-[:BREWS]-(br:Brewery {id: toInt(csv.beer_brewerId)});
//add the reviews
using periodic commit
load csv with headers
from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv
fieldterminator ';'
with csv
where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
//THIS QUERY IS PROBLEMATIC
using periodic commit
load csv with headers
from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv
fieldterminator ';'
with csv
where csv.review_profileName is not null
match (b:Beer {name: csv.beer_name}), (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})-[:REVIEW_COVERS]->(b);
//add an Anonymous profile
merge (p:Profile {name:"Anonymous"});
//add the anonymous reviews
using periodic commit
load csv with headers
from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv
fieldterminator ';'
with csv
where csv.review_profileName is null
with csv
match (b:Beer {name: csv.beer_name}), (p:Profile {name:"Anonymous"})
create (p)-[:CREATES_REVIEW]->(r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})-[:REVIEW_COVERS]->(b);
[
{
"op": "core/column-rename",
"description": "Rename column Column 1 to beer_name",
"oldColumnName": "Column 1",
"newColumnName": "beer_name"
},
{
"op": "core/column-rename",
"description": "Rename column Column 2 to beer_beerId",
"oldColumnName": "Column 2",
"newColumnName": "beer_beerId"
},
{
"op": "core/column-rename",
"description": "Rename column Column 3 to beer_brewerId",
"oldColumnName": "Column 3",
"newColumnName": "beer_brewerId"
},
{
"op": "core/column-rename",
"description": "Rename column Column 4 to beer_ABV",
"oldColumnName": "Column 4",
"newColumnName": "beer_ABV"
},
{
"op": "core/column-rename",
"description": "Rename column Column 5 to beer_style",
"oldColumnName": "Column 5",
"newColumnName": "beer_style"
},
{
"op": "core/column-rename",
"description": "Rename column Column 6 to review_appearance",
"oldColumnName": "Column 6",
"newColumnName": "review_appearance"
},
{
"op": "core/column-rename",
"description": "Rename column Column 7 to review_aroma",
"oldColumnName": "Column 7",
"newColumnName": "review_aroma"
},
{
"op": "core/column-rename",
"description": "Rename column Column 8 to review_palate",
"oldColumnName": "Column 8",
"newColumnName": "review_palate"
},
{
"op": "core/column-rename",
"description": "Rename column Column 9 to review_taste",
"oldColumnName": "Column 9",
"newColumnName": "review_taste"
},
{
"op": "core/column-rename",
"description": "Rename column Column 10 to review_overall",
"oldColumnName": "Column 10",
"newColumnName": "review_overall"
},
{
"op": "core/column-rename",
"description": "Rename column Column 11 to review_time",
"oldColumnName": "Column 11",
"newColumnName": "review_time"
},
{
"op": "core/column-rename",
"description": "Rename column Column 12 to review_profileName",
"oldColumnName": "Column 12",
"newColumnName": "review_profileName"
},
{
"op": "core/column-rename",
"description": "Rename column Column 13 to review_text",
"oldColumnName": "Column 13",
"newColumnName": "review_text"
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column beer_name using expression grel:substring(value,11)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "beer_name",
"expression": "grel:substring(value,11)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column beer_brewerId using expression grel:substring(value,15)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "beer_beerId",
"expression": "grel:substring(value,13)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column beer_brewerId using expression grel:substring(value,15)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "beer_brewerId",
"expression": "grel:substring(value,15)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column beer_ABV using expression grel:substring(value,10)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "beer_ABV",
"expression": "grel:substring(value,10)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column beer_style using expression grel:substring(value,12)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "beer_style",
"expression": "grel:substring(value,12)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column review_appearance using expression grel:substring(value,19)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "review_appearance",
"expression": "grel:substring(value,19)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column review_aroma using expression grel:substring(value,14)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "review_aroma",
"expression": "grel:substring(value,14)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column review_palate using expression grel:substring(value,15)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "review_palate",
"expression": "grel:substring(value,15)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column review_taste using expression grel:substring(value,14)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "review_taste",
"expression": "grel:substring(value,14)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column review_overall using expression grel:substring(value,16)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "review_overall",
"expression": "grel:substring(value,16)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column review_time using expression grel:substring(value,13)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "review_time",
"expression": "grel:substring(value,13)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column review_profileName using expression grel:substring(value,20)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "review_profileName",
"expression": "grel:substring(value,20)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/text-transform",
"description": "Text transform on cells in column review_text using expression grel:substring(value,13)",
"engineConfig": {
"facets": [],
"mode": "row-based"
},
"columnName": "review_text",
"expression": "grel:substring(value,13)",
"onError": "keep-original",
"repeat": false,
"repeatCount": 10
},
{
"op": "core/column-removal",
"description": "Remove column Column 14",
"columnName": "Column 14"
}
]
We can make this file beautiful and searchable if this error is corrected: Illegal quoting in line 8.
beer_name;beer_beerId;beer_brewerId;beer_ABV;beer_style;review_appearance;review_aroma;review_palate;review_taste;review_overall;review_time;review_profileName;review_text
Sausa Weizen;47986;10325;5.00;Hefeweizen;2.5;2;1.5;1.5;1.5;1234817823;stcules;A lot of foam. But a lot. In the smell some banana, and then lactic and tart. Not a good start. Quite dark orange in color, with a lively carbonation (now visible, under the foam). Again tending to lactic sourness. Same for the taste. With some yeast and banana.
Red Moon;48213;10325;6.20;English Strong Ale;3;2.5;3;3;3;1235915097;stcules;Dark red color, light beige foam, average. In the smell malt and caramel, not really light. Again malt and caramel in the taste, not bad in the end. Maybe a note of honey in teh back, and a light fruitiness. Average body. In the aftertaste a light bitterness, with the malt and red fruit. Nothing exceptional, but not bad, drinkable beer.
Black Horse Black Beer;48215;10325;6.50;Foreign / Export Stout;3;2.5;3;3;3;1235916604;stcules;Almost totally black. Beige foam, quite compact, not bad. Light smell, just a bit of roast, and some hop. A bit too light. The taste is light oo, and drinkable, with some malt, roast, hints of coffee. Nothing exceptional, but after all drinkable and pleasant. Light to average body. In the aftertaste some dust, somr roast, hint of caramel, and a bit of bitterness. No defect, drinkable, not bad.
Sausa Pils;47969;10325;5.00;German Pilsener;3.5;3;2.5;3;3;1234725145;stcules;Golden yellow color. White, compact foam, quite creamy. Good appearance. Fresh smell, with good hop. Quite dry, with a good grassy note. Hay. Fresh and pleasant. More sweet in the mouth, with honey. The hop comes back in the end, and in the aftertaste. Not bad, but a bit too sweet for a pils. In the end some vanilla and camomile note. In the aftertaste, too. Though the hop, a bit too sweet. Honest.
Cauldron DIPA;64883;1075;7.70;American Double / Imperial IPA;4;4.5;4;4.5;4;1293735206;johnmichaelsen;According to the website, the style for the Caldera Cauldron changes every year. The current release is a DIPA, which frankly is the only cauldron I'm familiar with (it was an IPA/DIPA the last time I ordered a cauldron at the horsebrass several years back). In any event... at the Horse Brass yesterday. The beer pours an orange copper color with good head retention and lacing. The nose is all hoppy IPA goodness, showcasing a huge aroma of dry citrus, pine and sandlewood. The flavor profile replicates the nose pretty closely in this West Coast all the way DIPA. This DIPA is not for the faint of heart and is a bit much even for a hophead like myslf. The finish is quite dry and hoppy, and there's barely enough sweet malt to balance and hold up the avalanche of hoppy bitterness in this beer. Mouthfeel is actually fairly light, with a long, persistentely bitter finish. Drinkability is good, with the alcohol barely noticeable in this well crafted beer. Still, this beer is so hugely hoppy/bitter, it's really hard for me to imagine ordering more than a single glass. Regardless, this is a very impressive beer from the folks at Caldera.
Caldera Ginger Beer;52159;1075;4.70;Herbed / Spiced Beer;3.5;3.5;3;3.5;3;1325524659;oline73;Poured from the bottle into a Chimay goblet. Appearance: Pours a slightly cloudy yellow/orange color with a half finger of fluffy white head. The head fades to a small layer on top of the pour. Smell: Very light and crisp. I'm definitely picking up the ginger, but it's not overly powerful. There is a slight sweetness from the malt as well. Taste: Very light and refreshing. The ginger shows up right away and then fades towards the finish of the sip. The finish is malty and bread like. Mouthfeel: The body is on the thin side with smooth carbonation and a very dry finish. Overall: This is a light and refreshing beer, but nothing spectacular. The amount of ginger is nice, but I would have liked to have more going on.
Caldera Ginger Beer;52159;1075;4.70;Herbed / Spiced Beer;3.5;3.5;4;4;3.5;1318991115;Reidrover;"22 oz bottle from ""Lifesource"" Salem. $3.95 Nice golden clear beer body with a nice sized frothy/creamy white head. Ok aromas..mainlly a bit of ginger speice and some bready malt..simple nice Taste very nice indeed..nice spicy ginger backed with slightly caramel maltiness..simple again but i like . Liked the mouthfeel of this one..very forward carbonation which helps the ginger effect and a lingering ginger in the after taste. Overall a simple ginger brew .I liked it "
Caldera Ginger Beer;52159;1075;4.70;Herbed / Spiced Beer;3.5;2.5;2;3.5;3;1306276018;alpinebryant;"Bottle says ""Malt beverage brewed with Ginger and ginger added"" Sounds redundant to me, but lets move on. Pours a bud light yellow with a tiny white head of small bubbles. The beer is almost as clear as a glass of water with some food coloring in it. Aroma of light ginger, a very light malt aroma but primarily odorless on the malt side. I wouldn't be completely surprised if there were some adjuncts in here because of the lack of underlying malt flavors. Taste is of a light adjunct lager with a dosing of ginger. Not surprising there. This is a light session beer, good for the warmer days of spring / summer. Mouthfeel is extremely light, high carbonation. Overall decent. This would be great if you were drinking beers on draft at the bar with some friends just hanging out. I wouldn't necessarily seek it out though to drink out of a bottle. "
Caldera Ginger Beer;52159;1075;4.70;Herbed / Spiced Beer;3.5;3;3.5;4;4;1290454503;LordAdmNelson;I'm not sure why I picked this up... I like ginger, and it was reasonably cheap compared to the other beers I was looking at. Pours a pale golden color with smallish head. Nose is largely uneventful, some ginger in there, a bit of pear, but mainly normal lager. Taste is pretty good, bringing a bit more of the ginger to the fore. MF was a bit fizzy, not terrible though. Easy drinker, I had no problem finishing the bomber. Interesting, but I probably won't get it again.
Caldera Ginger Beer;52159;1075;4.70;Herbed / Spiced Beer;5;3.5;4;4;4.5;1285632924;augustgarage;"Poured from a 22oz bomber into my Drie Fonteinen tumbler. Hazy titanium yellow body (which catches the shadows forming a beautiful mysterious gradient) with an incredibly dense pillow of magnolia cream. Heavy persistent head and rich creamy lacing. Pale malt, asian pear, and a hint of citrus in the nose. A vaguely tropical lager... Tastes very much like a well done APA, with a nice balance of pale malt and low hop bitterness. The ginger adds to the refreshing character, but isn't readily detectable at first (lacks any ""bite""). Medium-dry finish - very clean and extremely quaffable. I can imagine hibiscus and beets working in small quantities, though I think they omitted those for this version... Light bodied, pillowy, smooth and moderately carbonated. Don't go into this expecting a ginger beer (despite its name) as it has little in common with that spicy soft drink. This is a wonderful session ale though, and worth seeking out if you are a fan of light yet flavorful lagers. Would obviously go perfectly with sushi. "
Caldera Ginger Beer;52159;1075;4.70;Herbed / Spiced Beer;4;5;4;4;5;1283154365;MadeInOregon;"OK, so the only reason I bought this while shopping at Whole Foods was because I've never had a ""ginger beer"" unless it was ginger ALE...and we all know that's not the kind of ""beer"" we're interested in on this site! I was very excited to try this one!... When poured out it looks like a cheapo macro lager at first sight, then the slowly fading head suggests otherwise. The body is crystal clear and is a very light straw color. The head is bright white and slowly dissipates, but is initially quite thick. Smell is adjuncty, but there are slight notes of honey and some kind of herby thing going on...ginger perhaps? Can't really tell. From the smell there is obviously something different about this beer though. It has a unique spicy smell to it and reminds me a lot of basil, not ginger. I really can't quite place everything that I smell, but it is a very nice aroma. Superb fragrance for this beer, though definitely not a ""ginger beer"" based on the smell. The taste is very unique also. It's kind of like a spiced pilsner or kolsch but the ""spice"" is kind of hard to identify. It does not taste like ginger. This beer actually reminds me a lot of Bison's Honey Basil ale. There is some definite astringent burn in the upper throat after swallowing that is no doubt from the ginger, but that is the only ginger I can detect with any certainty. It is only slightly hoppy and malty. This a very enjoyable, very drinkable beer (I could easily drink 2 22oz'ers) but I think it's failing in its claim to be a ""ginger"" beer because I don't smell it, can barely taste it, and can only really detect the ginger's physiological effects of a warm throat and stomach. So, rating this one is hard; I've never had a ginger beer so I don't really know what one ought to taste like...but then again I can't really tell if I'm tasting ginger here or the combination of other things. So confused. My recommendation to you Caldera folks: ADD MORE GINGER! There's obviously enough of a curiosity about this style to not hurt sales if it was strengthened. I for one could handle it. "
Caldera Ginger Beer;52159;1075;4.70;Herbed / Spiced Beer;4;4;3.5;4;4;1277557990;rawthar;Notes from 6/24 A: Bright golden glowing beer in a moment of clarity with a lively white head of feathery fluff S: The ginger is definitely there, or am I smelling my Indian dinner? Almost cake-like in its malt aroma, sharply bready with a slight edge of sweetness T: Nice clear malty throat taste, reminds me of strands of complex sugars and grains, ginger is more subtle than I expected, more of an undertone than a backbone M: A refreshing light beer feel, like a pilsner or summer ale D: If this was a sixer instead of a double-deuce, I could see this being a fine picnic pounder Overall, pretty impressed for the particular style
Caldera Ginger Beer;52159;1075;4.70;Herbed / Spiced Beer;3;4.5;2.5;3;4;1275779250;Halcyondays;22 oz. bomber, A: Pours a clear yellow with a mild white head, good retention. S: Great nose of ginger, honey, perfume. T: Rather light upfront, it reminds me of Lawnmower, with a hint of ale fruitiness/Kolsch-like almost. Good ginger honey notes on the back end, not taking over the beer in any way. The ginger flavour is clear, but I wanted it to come out a little more in the end. M: Very light-bodied, watery, light base beer for sure. D: An easy drinking spiced beer, this will offend no one, but there's not a complexity to this brew at all.
Caldera Ginger Beer;52159;1075;4.70;Herbed / Spiced Beer;3;4;3;4;3.5;1273109020;RangerClegg;"Is it possible for a bottle to be a novelty product? I bought it cause it's the only bottle of Caldera I've ever seen, so I guess so. Stoked to be the first to review a beer! That's a lot of responsibility so I might as well give it a thorough review. Poured into my New Belgium Tulip. A - Clear golden color with a bright white 1"" head that slowly fades to a ring around the top. Lacing is minimal, but still there and fighting to cling to the glass S - Smell is of ginger and honey. Very appealing. T - First hit is of ginger. Not too strong or biting but just the right amount. Fades to a sweetness on the tongue that is sort of perfect and then... a little bit of bite from the hops making their presence known. M - Medium bodied and full. A nice round beer for the summer. Not too heavy, definately not watery. Not very good at describing it other than it's good. D - I really like this beer and I could probably put 2 or 3 glasses away, so one bomber is enough for me. I think 2 bombers would be too much, but I could probably drink one and half, so I think I'll have to stick with the one. Overall this is a pretty good ginger beer. I think that for my money though, I'd rather buy Trade Route's Ginger Pale Ale. If you've never had a ginger beer, Pick it up. "
Caldera Oatmeal Stout;10789;1075;7.20;Oatmeal Stout;2.5;3;3;3;3;1316025612;Beerandraiderfan;Brown in color, somewhere between a porter and a brown ale. Lacking in aroma, but no off stuff. Same with the taste, lacking flavor, complexity, just went with smoothness. No off flavors though, so I can't say this is bad, just unadventurous, especially for Caldera, whom I think is generally underrated. You really have to search to pull anything out of this in terms of the usual chocolate/coffee flavors, really, the only thing I can tell is that the oats did their job, because this is smooth and unoffensive. Other than that, extremely pedestrian.
Caldera Oatmeal Stout;10789;1075;7.20;Oatmeal Stout;2.5;1.5;2.5;2;2;1103502339;RedDiamond;Caldera presents yet another circumstance where the brewery does not operate a brewpub, doesnt bottle their beers, and is located 300 miles from my home. To review their beers I traveled to their hometown of Ashland, OR and drank at the Ashland Creek Bar and Grill. This may have been a mistake. Though I had other reasons to visit Ashland, its disappointing (to say the least) to travel 300 miles and be served a spoiled beer. Both the Oatmeal Stout and Ashland Amber were of poor quality at the Ashland Creek Bar and Grill. In the case of the Oatmeal Stout, a nice measure of cream and a wayward thread of mint were marred by a sulfuric smell and likely bacterial infection. Though I cant say for certain, my best guess is that the house tap lines were something other than sanitized. I will attempt to revisit and re-evaluate this beer. But for the time being, its important to ask a pertinent question about quality control. Caldera is a 10 bbl microbrewery in a small town. How much responsibility do they have towards assuring that taps serving their product in their hometown are kept reasonably clean and free of bacterial encroachment? My answer to this question is that the brewery does have some responsibility to assure quality pours in its own hometown. This is especially so when they operate no pub of their own. Not only does this effort protect the consumer from being served a spoiled beer, but the enforcement of quality control measures at the point of consumption simply makes good business sense. Till then, theres nothing I really care say about this beer other than to wish whoever pursues it greater luck than I had at Ashland Creek.
Caldera OBF 15;12386;1075;5.60;American Pale Lager;4;3;4;4;4;1062311123;beerguy101;"More of a 'dry' than a lager, tasted at the 2002 Oregon Brewers Festival. Orange color, orange flavor in nose. Light malts and fairly aggressively hopped; yet it is not very bitter. Interesting taste, complex and subtle. Light yet flavorful. Mouthfeel is full and round. Finish is clean and smooth. Aftertaste is slightly bitter. Nice beer. Would be a great beer to sip during a hot summer day. "
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3;4.5;4;4.5;4.5;1325478004;UCLABrewN84;Pours a murky light brown with a 1 inch fizzy tan head that settles to a film on the top of the beer. Small dots of lace slowly drip back into the remaining beer on the drink down. Smell is of smoked meat, smoked cheese, campfire smoke, etc. Taste is of smoked meat/cheese, campfire smoke, wood, and a slight cocoa/coffee flavor on the finish. The aftertaste is also cocoa/coffee with just a hint of the smoke flavors. This beer has a crisp level of carbonation with a bubbly mouthfeel. Overall this is a very good rauchbier from Caldera that has a bit of a different flavor than German rauchbiers.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4;3;4;4;1325360812;zaphodchak;Faint sudsy head with some with some dissipating fine surface. Light ruddy brown. Some lace. Smokiness in the nose along with pickling vinegar (faint), and some slightly musty malt. Plenty of bitter, slightly tangy, tannic beech smoke. Traces of sweet toffee on the finish. Feel is standard, smooth, but went flat quite fast.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;3.5;4;4;1322506304;Tilley4;A new arrival to the West TN area... Pours quite a bit lighter than I was expecting. Almost like a brown ale? Good head retention though... Smoky bacon aromas upfront mesh with a sweet maltiness... This is definitely very smoky but not overpoweringly so... Its subtle at times and powerful at others on the nose... Like being in a smokehouse after the meat has already been removed... Very interesting... Sweet caramel malts surprise me as I thought the smoke would hit hard right off the bat... The smokiness here is beautifully done... Not a smoke bomb but rather the smoked meat flavors run parallel to the sweetness darting in and out, here and there... Very good example from Caldera here. Excellent use of the smoke with its subtleties...
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4.5;5;4;4.5;4.5;1320494397;mikedrinksbeer2;Sampled 10/30/11 - Transferring the notes. A ruby pour with a half finger, off white head. Opaque. Smells like bacon it's so smoky. Very much a wood smoked scent, great on an autumn night. The flavor is full but not overbearing, smoky with a hint of sweetness. I dig this a lot, will seek out other rauchbiers for some comparison.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;4;4.5;4;1320140421;dbmernin83;This is my first rauchbier. Pours a burnt amber. Good head. Holy smoked meat! This has huge beef jerky on the nose. Salty smoked meat goodness. Tastes about the same as it the nose. Wood, smoked meat, cured meat, soy sauce. This is delicious for the first 6-8oz, then it gets to be a little much. I imagine after having this a few times, you appreciate the flavors more. Maybe I should've picked a tamer rauchbier to be my first
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;4;4.5;4.5;1319847514;titosupertramp;A: Pours a rich, ruby color, clear. Maybe a finger of off-white head. Thin cap with thick ring of bubbles around the edge of the glass. Light lacing. S: Wow. Smoked meat balanced by caramel, bready sweetness. I wish they would make this smell into a cologne..no shit, I'd wear it to special occasions. T: Taste is equally as good. Smoked meat with just a hint of peet. The nice thing about this beer is the smoked characteristics don't overpower the rest of the beer. The caramel, bready malts hold up nicely and there seems to a slightly hoppy finish. M: A little on the light side, but it's still manages to be somewhat creamy. O: I had heard some good things about this beer and it certainly lived up to my expectations. It's a very well crafted beer where the smoke asserts itself, but doesn't drown out everything else. I'll pick this up again without a doubt.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;5;3.5;5;5;1318802642;optimator13;Pours a mahogany color, rich, with a tan head. a finger, didn't stick around. Holy smokes! This is one of the most smokiest beer I've ever had! BUT. It's balance and not one sided. Smoke, cured bacon, rich caramel malts. More smoke. Ok, maybe it one sided, but it's heavenly. Rich caramel malts and salty cured bacon strips. Bacon lover right here, so, I don't feel the need to go on. Lighter, but medium in body. feels fine. Nothing tremendous. Aroma and flavor alone are mouthwatering. Bravo. More please!!!
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;4;4.5;4.5;1318290101;Blakaeris;Pours light caramel brown with reddish highlights. The crisp white head doesn't hang around long, but quickly dissipates to a thin ring. Aroma is intense meaty smokyness. Underneath is a mild malty sweetness. Taste is really interesting. The smoked meat quality is retained, but there is also a generous earthy, woody character. Caramel and toffee really round things out. Finishes with a mildly dry cedar character. Mouthfeel is a chewy, medium body. A flavorful brew. Strong smokiness is tempered by the rich caramel malt qualities. A real winner that could bring the non-smoke lover around.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;5;4;4;4.5;1318289482;bashiba;Poured a slightly cloudy deep amber/red color with a thin soap ring of head. The smell is amazing, big bacony smoked pork Rauch goodness. The taste follows the flavors nicely with a big smoked malt flavor with a nice bit of underlying sweetness, very pork like and very flavorful. Has a nice light bitterness in the finish that helps even it out very well. The mouthfeel is very slick and oily. Great Rauchbier!
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;4.5;4;4.5;4.5;1316405909;Klym;Big thanks to N2168 for knocking this off my wants. Poured into a stone nonic and shared with my buddy Ryan. This was quite delicious. The pour made it seem a little lacking in carbonation, and while indeed it was light in carbonation I think it would have been awkward if it had been heavier considering the taste profile. This beer does such a good job of hitting the sweet and savory side of smoke. Nice big campfire smoke smell and taste without any roughness to it, with a nice smoked bacon savory sweetness. This is easy to drink and just downright delicious, would love to have a keg of this by my desk.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;4;4;4.5;1315696563;flexabull;On tap last night at the Caldera Tap House. Pours a bright and clear brown color, with a small white head. Aromas are quite potent. Lots of interesting smoke notes here, smoked meat, charred wood, like a camp out in a glass. Very nice. Flavor is like the nose, but toned down just a bit. Light caramel, bready, and slightly sweet up front. Beer then settles Into a smoke house flavor, hints of charred wood, and jerky. Mouthfeel is good, full, smooth, but not heavy at all. Overall, this is a really well made smoked lager. The nose is wonderfull. But the beer turns out to be plenty drinkable, I usually am a one and done with smoked beers, not this one. Another great offering from Caldera.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;4;5;5;1315014054;Bung;22 oz. Think I picked this up in Chicago Binny's Oak Park. Solid amber/brown pour, half finger of off white head disappated to a ring, but lasted. Smoked malt, peat, canadian bacon and some malty caramel. Starting out real well. Taste, solid dose of smoked ham, bacon, peat and a woodiness. Caramelly malt body is there, almost some faint raisin or apple cider, then finishes with solid bbq. The real deal, far far and away the best American version I've had of this style. So few try this style, even less accomplish the task. Lighter side of medium bodied. Coats well, goes down smooth, no alcohol. 7.4 is a little larger than some for the style, but it doesn't show itself. Best brew I've had in a while. First I've had from this brewery, if their others are even close to as good as this I won't be disapointed.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4.5;4;4;4;4;1314752229;oberon;Poured into a 1/2 liter stein a deep rich amber/bronze with a fluffy one finger head that took its time fading.Sweet smoke,brown,sugar,a bit of alcohol in the nose,mellow and sweetish,I found it appetizing.Cherry wood sweetness and light peppery spice in the nose,its gentle sweet smoke instead of in your face,mellow but assertive enough.A real nice smoked bock beer,I will grab a few of these this fall while eating alot of smoked meat off my smoker.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;4;4;4.5;1312403394;t420o;A- Semi aggressive pour produces a 1-1/2 finger very light brown head that rests atop a beautiful deep copper colored beer with nice clarity. Nicve lacing. S- Very similar to a smoked porter but more smoke. The smoke smell is beautiful. It smells like a campfire and the cherry wood is definitely present. Excellent smelling beer. T- WOW! They were not kidding on the bottle when they said it has an intense smoke flavor. It is excellent and I could see some folks that the smoke is too in-your-face, but I love smoked beers and I love this one. This is as smoked wood forward as I've ever had. It's pretty much smoky wood, a slight malt sweetness, and finishes woody and smokey again. This is a perfect fall beer. M- Nice smooth mouthfeel with good carbonation. O- Not too complex because of the intense smoke taste but it works excellent in this beer. I will definitely be picking this up again.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4;4;4;4;1312162337;DarthKostrizer;Look: Burnt orange in color with 1/4 inch head and no retention but did have some lacing Smell: This beer smells like a campfire in a bottle also reminds me of burnt oak chips or smoked salmon Taste: The flavor is this beer is quite unique. The smokiness is there in abundance and is pretty much just liquid smoke. Again the taste does follow suite with the noise there is a big smoked salmon flavor Mouthfeel: Medium body and medium carbonation Overall: If you love the idea of smoked anything actually you will love this beer. It is hands down one of the most smoky beers I have had to the point where it almost looses balance like say Alaskan smoked porter or Ass kisser smoked porter. However if you are into smoked beers this one is a must try
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3;4;4;4;4;1312070406;MrVonzipper;Bottleshare from Darthkostrizer with BHOBS and Alucard4 Pours a hazy reddish brown with a very quick dissipating bubbly head. No retention obviously. Holy shit. Smells exactly like uncooked applewood smoked bacon and/or smoked salmon(not fishy). Very nice yet strong smoke. Tastes just like it smells. Very strong different smoky flavor but Good. Good carbonation. Smooth and Medium bodied. Overall at some point in trying this beer You Will Say Holy Shit! It is Unlike any any beer I've had and any smoked beer for that matter. Its very interesting but Good. Although it very hard to drink alot of it. Definitely a bottleshare.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3;4.5;2;3;3;1311558510;Beerandraiderfan;Amber to yeloowcolored, was expecting darker, kind of even had a good degree of clarity to it. Holy cherry wood campfire smoke! This smelled just like you were out in the woods. Whoa, I could only take a small sip at first, massive liquid smoke feeling in the mouthfeel. Ugh. Its not so much as 'bad' as opposed to 'challenging'. I must admit, I could not even finish a taster of it. This is the most intense smoked beer I've ever come across, by far. I mean, beer geek bacon was a walk in the park compared to this. I could smell it all day. As far as drinking it, I'm cool with 1oz at a time, its that intense. If you like smoked beers, then check this out. If not, stay away. I kind of like them, trying to get into them more, so I'd try it again next time, but for now, I'm not worthy.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4.5;4.5;4;3.5;4;1309310508;TheWhiskerReview;Pours a brilliant black with ruby tones and a 1-finger tan head. Weak retention and lace, as expected from such a malty brew. The nose is a smoky, malty blast of barbequed pulled pork, woodsmoke and brown sugar with undertones of baked apples and peaches. Nothing over-the-top here- good balance and elegance in the aromas. And I dunno if it's just me and my mental associations, but I could swear I smelled the BBQ sauce in this too. The palate, much like the nose, is hugely smoky- more bbq and toffee flavors- with a medium-body and a slight creaminess from the malt. The hoppiness is mild while the smoke, naturally, is what lingers on the nice finish. A wonderful effort overall. I wouldn't go so far as to say world class, but the brew does have a nice bit of elegance which always gets more points from me. And the smokiness carries a lot of power without being too heavy.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4.5;3.5;4;3.5;3.5;1307850875;Elimination;I have been thinking of picking up a bottle of this for a while pours a deep deep red, glowing, standing out a lot smell of slight smoke, peat, a bit of cherry, bbq Taste is mostly peated malt smoke, a lot of it...i was expecting more smokey, not peated. still a bit of darker, roasted fruits, a bit of burnt sugar, some peanut but overall makes it pretty unique. Mouthfeel is really smooth, lower carbed tickles the tongue just right, goes down well Overall its not bad, but as far as a rauch, feels like to much of that peated taste, dont know if I would pick it amongst other smoked beers.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4;4.5;4.5;4.5;1306128988;DoubleJ;"""Warning, this beer has an intense smoke flavor."" Warning...'cuz the flavor may cause me to overdose? I'll leave it at that and hope I don't O.D. off this 22 ounce bottle. On to the beer: The chestnut colored body is a looker in the stange glass. On top, the head has a beige color, a somewhat creamy texture, several groupings of lace sticking around and retention. The rauch part is done extremely well; mouth-watering jerkied meats stand out above with a little sweetness and a kiss of leafy hop. There's a lot of meat on the bones of this beer. Loads and loads and maltiness and medium smokiness make this a winner. The two run in sperate stages and never cross into each other's territory, which in this case I adore. Its got the smokiness that I would find in a summer sausage. On the malty side, there's loads of caramel. Little notes of ash give me the impression that I'm at a campfire. Hints of brown sugar. Alcohol slowly gets noticed, but in a good way; here it brings notes of raisin. There is a moderate hoppiness that can be sensed for a brief second, catch it before the smoke and malt beat it down. On the fuller side in terms of mouthfeel, quite smooth with the bubbles very small yet enough to be felt. If I hadn't stuffed myself with Chinese food earlier in the night, I may have been more tempted to overdose on Rauch Ur Bock. Only kidding, I have a good idea when to stop. Warning, you may be temped buy more bottles after you try your first. In short, superb. "
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;4.5;4;5;5;1305926255;Deuane;"A-Bright, crystal clear, copper with a medium tan head that slowly fades to a thin cap and leaves light lace. S-Campfire smoke with a subtle hit of applewoods smoked bacon. Sweet caramel malt and spicy pepper notes accent in the background. T-Yes, this is a smoked brew but it never comes off as over the top. In fact it is about as perfect as it can get. Dry, woody smokiness and spicy, herbal hops dominate. Caramel malt sweetness provides a healthy backbone with tones of toasted biscuit, apple and buckwheat honey. M-Medium bodied with a feel that is bigger than it really is. Smooth and slick with a drying, woody astringency in the finish. Nice lingering sweet smokiness. D-Simply put---&gt;OUTSTANDING! Quite possibly one of the finest Rauch beers I have had the pleasure of imbibing! This is a beer I wish I would have tried sooner so I could have gone out and stocked up on. Well done Caldera, this is a beer you should be VERY proud of! "
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4;4;4;4;1305856857;Mattybeerguy;Overall a really nice and interesting beer. I saw this on the shelf and hadn't tried anything yet from this brewery but looked interesting. Figured I would try it. It was really a nice beer. It definitely had a lot of smoky and meaty flavor to it! Very interesting and nice beer overall, I would drink it again.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;4;4;4;4;1305469906;micromaniac129;Amber brown in color with very little head but a nice ring. Nicely carbonated. Smells like a camp fire, malts have a good sweet character with an abundance of smoke. Taste is quite good with smokiness being pungent but not overwelming. A sweet tasting bock with smokiness coming through around mid drink with a smooth mellow finish. A good warming smoky beer.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;5;3.5;4;3.5;1305329412;beagle75;Poured from a bomber into a shaker pint glass. A: Clear, dark amber color with one finger of diminishing off-white foam head. Light lacing remains on the glass. S: Sweet woodsmoke is intense, developing fruity and savory complexity that distinguishes itself above the Bavarian archetypes. T: Begins off-dry, with caramel and sharp woodsmoke that becomes more dry by the middle. Acidity flares early but remains mild overall. Smoke nearly persists throughout, but diminishes by the clean, short finish. M: Thin to medium viscosity, wet on the palate but becoming a bit too insubstantial, with moderate carbonation. D/O: This Oregon-brewed rauchbeer develops some of the most intense woodsmoke essence encountered thus far, but it may be at the expense of the strong lager that is its base. Deciphels of the imports from Bamberg would find this beer's intensity surprising--if not off-putting--but it does struggle to leave any impression other than aggressively pungent woodsmoke.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;4;4;4;4;1302401846;northyorksammy;Complex enjoyable smoked. Tasty rich malt,caramel, woody,spicey, and balanced. Leans a tad to sweetness rather than bitterness. The smoke is significant in the aroma but not overwhelming. Above average mouthfeel. Yellow coloured body. Most drinkable.Thanks Augustgarage.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4;4.5;4;4.5;1301454480;vette2006c5r;"This beer pours a dark amber color, with a perfect size head that did dispate quickly. The smell is strongly of malts, and a smokyness. The taste starts off very malty, smoked flavors, then finishs with a smoked sausage like flavor. The aftertaste is strongly of a smoked meat; and the flavor stays on your palette for some time, also nicely carbonated. Overall fantastic beer, very odd, but still enjoyable. "
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;3.5;3;3.5;4;1301023832;EvanEngelstad;This is the first Rauchbier that I have reviewed. I had it at the Bier Stein in Eugene, OR. -a dark but translucent amber with a small head that remains on the edge, with slight lacing in the middle -aroma: smoked bacon, smoky wood flavor (cherry, beechwood), smoke in general -medium carbonation -crisp lager flavor at the beginning that is then overwhelmed by the smoky flavor, some caramel undertones, feels like you're exhaling a campfire -smoky flavor remains in your mouth indefinitely? My friend could still smell smoke on my breath an hour later on the way home even though I was in the back seat and had a breathmint! -leaves a dry, spinach-like feeling in the mouth The smoke was pretty intense. I enjoyed it okay, but I'll have to try some other Rauchbier to compare...
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4;4;4.5;4.5;1300936020;djeucalyptus;Pours a rich burnt caramel hue with some deep amber hues... dark for a rauchbier. a surprisingly dark tan head slowly fades and leaves ample lacing. aroma is pungently smokey... sweet malt, sweet smoke, and some salted caramel in the nose. the taste, as expected, is smokey. Not the smokiest or most pungent smoke profile I've experienced, but damn up there. and I think it's the intense rich malt and sweetness from the malt that keeps the smoke slightly tamed. A touch of lemon and citrus fruitiness in the finish which blends perfectly with the cherry smoke. It's not as crisp or dry as other Rachbiers, and it seems a bit more full-bodied, with almost a touch of syrupiness to it. which is kind of an interesting take on it. I'm digging it. I'm not usually one to say this, but it's almost a touch malt-forward. Not that it's a bad thing. I think this is probably my favorite domestically produced Rauchbier I've had the pleasure of tasting. It really hits on all cylinders. A touch sweet and malt forward, but all in all, it does what it's going for and works beautifully. Definitely worth seeking out.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;4;4.5;4;4;1300237348;ccrida;On draught at The Beer Stein, Rauch r Bock is chestnut brown with a small off-white head that leaves no lace. Nice glow to it though. Smell is smokey and sweet. Both cherry and beechwood were used, but I'm getting mostly cherry in the nose. Taste is really quite smokey, the beechwood really asserting itself here, although the sweetness of the cherry wood and the malt is no slouch either. The smoke has a sharp phenolic quality that I get from peat, but with the sweetness I think it works well. Note it's not cloying, the sweetness is enjoyable and provides relative balance. Mouthfeel is slick, some softness, a medium bodied, and smooth. Nice. Drinkability is really quite good for such a smoke bomb. No doubt inspired by Aecht Schlenkerla, with the body and color of the marzen, but the punch of the ur bock, it one of the best stateside examples of the style, which is rarely attempted and even more rarely successful. I have to say, this was really good, and with just a touch less phenols, would be up a notch easily.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;3.5;3.5;3.5;3.5;1297290394;cooch69;Got this in a 22 ounce bomber. It poured a deep bright brown with a pretty small head. Aromas of smoked kielba, and dark roasted malts. This beer was OK but for a style that I like so much it did'nt really please as much as I thought it would. It had a nice amount of smokiness to it. Really obvious and pretty strong but not charred. But the oily consistency of the beer along with the huge saltiness made the beer less than I was hoping for. It was still a beer that I'm glad I grabbed. They don't make many in the style anyways.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4;3.5;3.5;3.5;1291959798;DogFood11;When I'm in the mood for something different from my usual assortment of IPA's I usually reach for a smoked beer like a Rauchbier or Porters. Wow this is the mother load of smoked dominance. Nothing subtle about this liquid smoke bomb. Concentrated ash and dried aromatic kindling. Damp Tobacco just adds to the one sided affair. If I had to reach for some balance there is a faint raisin type sweetness buried in the finish. Notes: I'd be interested to see exactly how they brewed this beer. The smoke seems more of an extract additive than natural smoke. A bit much for me. However, a 12oz bottle would have been more appealing for one sitting and it has nothing to do with the moderate ABV. Its a rich SOB.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;4;4.5;4;1291254447;brewandbbq;22oz bottle. Pours clear amber with a tight, half inch head of bone. Thin but webbed lacing and a partial skim coat for the duration. Aromatics lead off with a blast of smoked malts and caramel. Quite meaty and plump with plenty of doughy malt and smoldering wood. Very nice. Medium bodied with a crisp, slightly tacky mouthfeel. A hint of chew adds some substance. Sweet malt and wafting smoke start the palate. A crisp, clean Munich profile is the perfect arena for plenty of Beechwood smoke with hints of bacon and char. Finishes with unrelenting smoke and rich malt. Great beer. Loads of smoke and very authentic.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;3.5;4;4;3.5;1286839186;Fatehunter;A - Poured out of a bottle into a tulip glass. Lots of bubbles, almost transparent, rust-red color. No head. S - Smoky, smoke smoke. Smells like right after I get the BBQ going but before I throw any meat on the grill. I also get a green olive scent at the beginning. T - Smoke. Burnt wood. Sweet malt at the end. No bitterness at all. I think the smoke mellows out the intense malt sweetness that usually accompanies a bock. M - Very crisp, it is a lager after all. D - A good beer. There are not too many smoked beers made, so for that reason alone I tried it. Well worth it, though it was not my favorite smoked beer.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3;4.5;4.5;4.5;4.5;1286679032;hopsbreath;Deep cherry body with a faint beige head the recedes to nothing. No cap, no wisp ring, no lacing. Can't say this looks like anything special. Smokey and spicy summer sausage is all I can smell no matter how I try. It is however a wonderful aroma that I really enjoy. Wow! We have liquid bacon in a glass here! Although initially the cured meat taste is so intense I can't look past it, I was finally able to pick on its other dynamics half way through the bomber. Sweet stone fruits and a touch of orange zest add their nuances to the flavor. Its more complex than I usually find smoked beers to be and I can really enjoy it! Semi-thin in body with fine prickly carbonation is a nice contrast to such a powerful flavor profile. Anything heavier may have been too much. Finishes clean. I found this a little difficult to drink at first due to its uniqueness, but grew accustomed to the pungency. This is a nice sipper if given a chance and I'm really glad I tried it. Recommended.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;4.5;4;5;4.5;1285545349;augustgarage;Poured from a 22oz bomber into my Ayinger Celebrator Doppelbock glass. Brilliantly clear rufous body with faint sienna then amber highlights. A faint yellow-ish beige head persists. Light soapy lacing. Melanoidin drenched smoked dark brown sugar laden bready malt aromatics. Simple but absolutely entrancing - takes hold of your reptile brain like bacon. Sweet fruity malty palate entry suffused with delicate layers of smoke. I can't quite tease apart the beechwood and cherry, but the latter adds a bright complexity to the darker tones of the beechwood (which is more standard for this style I believe). Fine smoked ham, pink peppercorn, carmelized winter squash, rye bread, maybe a hint of treacle...at some point the analysis shuts off and the enjoyment takes over. Really well done, the best domestic Rauchbier I've tried thus far. Light-bodied, moderately carbonated, with low astringency. I envy anyone who has access to growlers of this - the drinkability is superior as well as the flavor.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;4;4;4.5;1284135689;Slatetank;I shared this bottle with tenderbranson69, picked up at Al's of Hampden. Poured chilled from the 22oz into a tulip and snifter. a - a beautiful bronze color w/ ruby highlights, mild haziness w/ translucent clarity and thin cream cap which settles to a ring of tiny beads of carbonation S - There is a very intricate aroma of sweet malt combined with woody smokiness. The hardwood aroma is earthy with a slight hint of caramel from the malt and the smoke is very aromatic with a light stone fruit ester in the background M - The feel is rich with med full body and mild dry smoky texture w/ light bitter tinge and moderate carbonation w/ semi-dry finish T - I enjoyed the brief sweet perky malt which has mild nutty aspect and slight bready quality. The smoke flavor is moderately strong w/ a mild woody and dry flavor not unlike sweet smoked jerky. The taste has a nice herbal hop complimenting the malt bread crumb taste and caramel w/ a smoke that lasts into the semi-sweet finish A - a great Rauchbier, one I could enjoy frequently if it weren't such a large bottle, the mid 7% hinders it slightly too, but this was great to share and I loved the complexity of bock malts w/ smoke and smoothness from the lagering. It is a beer I would like to see more brewers attempt, this is a good representative of the style.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;5;4.5;4.5;4.5;1283136243;Jason;22oz brown bomber with no freshness date. Decent sized head with a faint crackle but still a sticky lace, bright amber color. Smells of wood smoke, dry and not bacon-ish with a thick maltiness and peppery alcohol. Big body, slick and smooth. Yeah, the smoke is big but not over the top ... Dry and almost ashy. Malt stands tall with tones of toasted bread, treacle, dried grass. Mild hopping goes a tad herbal in the finish, a little red in the cheeks from the alcohol. Smokiness lingers far into the after taste. So smoky, so tasty ... Love the different woods used on the malt. Alcohol is clean and nearly hidden until halfway through the bottle, a big quaff!!
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4;4;4;4;1281495119;Proteus93;A: Quite a ruby red hue... deep, rich, almost sporting a soft glow. There's a bit of a sandy colour in the head. Not much for lacing, but the glass seems to be playing a role in that, as it has had a couple different brews in it, all of which laced poorly. S + T: I thoroughly enjoy a good rauch, and this one performs quite well in the traditional 'ham and cheese sandwich' sense. It's not overly smoky, which is a positive thing in that it allows some of the other delicate scents and flavours to shine. Of those, I pick up on a light - but noticeable - fruitiness, both in nose and on the palate that seems a little odd. worth note: after writing the above, I noticed the print on the side of the bottle to see that cherry wood is used in addition to beechwood. That would explain the fruitiness noted. M + D: Body feels a little lighter in the mouthfeel, but seems to pick up a little weight after going down, however little sense that might make. The alcohol content is perhaps a little high, but a little slower sipping never hurt anyone. Not a bad take on the style, though I think I personally would have enjoyed it better if the actual smokiness were a touch more robust.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;4;4.5;4;1281303716;SShelly;Pours dark amber with a short white fizzy head that fades fast. Aroma is BBQ and smoked pork, some sweet malt and a touch of chocolate. Flavor starts out like a smoked pork sandwhich, nice smooth lagered finish. Smoke and sweet malt stick in the mouth something fierce. A beer that performs as advertised, smoke meat and lager all in one, not really a style I want more than one of but still tasty.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;4;4.5;3.5;4;4;1277846123;zoso1967;"This beer pours a very clear and attractive shade of ruby brown. Much less dark than I had anticipated, and carrying a diminutive, but attractive head of parchment foam that leaves very nice lace. The smoky aroma of this beer is very nice. It smells like the smoke that would waft from the smoker at a little restaurant in my home town of Traverse City, Michigan. Porky, sweet and delectable with notes of brown sugar. I suddenly have a huge craving for an ""all meat mess."" The flavor is also quite nice in that the smoke is not too overpowering. Other flavors include sweet dark malt, brown sugar, a bit of cinnamon and leather. Quite nice and well blended. The body is medium with a mouthfeel that seems a bit sticky, but is pretty good. Surprisingly drinkable, and would be great (of course) with BBQ. Not the first smoked beer I have had, but the first I have reviewed. This one makes me want to seek out more. "
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;4.5;3.5;4;4;1275779614;Halcyondays;22 oz. bomber, A: Pours coppery with a medium head, solid retention, no lace. S: Beautiful sweet smoke smell, mix of bock malt and wood/BBQ. T: Not as intense in the smoke arena as Schlenkerla, that's fine. As with the nose, the baked caramel sweetness adds great flavour dimension, with cherry/wood?, mesquite, and sweet BBQ sauce. Really nice interplay of flavours. M: A tad too light in body for 7.4%, but very smooth, bit creamy. D: This is the best of the Kettle Series I've had. A very well made rauchbier, in the same league as Schlenkerla a cheaper price. Rare style too. Good job Caldera.
Rauch √úr Bock;58046;1075;7.40;Rauchbier;3.5;4.5;4.5;4;4;1273021280;msubulldog25;"A nice 'surprise' tap at Bailey's; grabbed a 10 oz. pour ($2.50). A: Deep auburn with the finest haziness; a brief ivory head (less than 1/2 finger) crests then dissolves. What remains is a broken swirl of film and a creamy ring. Decent streaming carbonation. S: Lovely of savory smoke and sugared spiciness...a malty, caramel-laden lager covered gently with grainy husks, burnt yet surprisingly sweet. Strong enough to be smelled from 1-foot away in a crowded room. T: Toffee and spice (notable cinnamon) with a candied fruit after-effect. Oh yeah, a good deal of smoke - a sweet mesquite, reminiscent of barbecued brisket. Herbed and a little tang in the finish. Enough intonations of fruit and a fleeting tartness. M: Velvety feel with a slight prickle (less from carbonation, more from an earthy ground spice). Medium body that borders on heaviness (not unexpected: it IS over 7%). Maltiness coats but isn't cloying; smoke doesn't intrude too much. D: Despite a heavenly aroma and feel and good flavor, this 'only' can muster a 4.0, simply due to a hefty alcohol girth. It's a touch on the sweet side (ur-bock) but the smokiness is well done. Sure it's worth a glass (or two) and is one I'd definitely have again. "
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);3.5;3.5;4;4;4;1251327677;NJpadreFan;Caldera- Pale Ale Picked up at Grape & Gourmet (VB) A- Light golden orange with a small fluffy white head. S- Light citrus and pine hops. Slight buttery maltiness. T- Buttery biscuity malt with a nice lemon/ grapefruit citrus and pine hop body. M- Buttery sweet and malty with a nice sweet and bitter hop bite. Overall- Nice malt/ hop balance. Very good sessionable can!
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);3.5;3;3.5;2.5;2.5;1250928902;vacax;12 oz. can poured into a pint glass. I really like cans for beers like pale ales that are not meant for cellaring and am glad to have another one available in SoCal. Cool green tab but sadly no canning or best by date. Pours a nice rich gold with a pure white head that grows excessively. Slow pour down a tilted glass and cannot even get the whole can into a pint glass. The retention is good, however, and lacing is great. Lots of bubbles cascading upwards from the bottom of the glass. The aroma is mild and consists of a bit of hoppy earthiness and some candied oranges. The flavor starts with a mild hops bittering and quickly adds a touch of sweetness to balance it out. Earthy and slightly piney with bitter sappy sugar.. The bittering is not high, but there is little aroma hopping evident or much malt complexity either. This is a very light pale ale with little going on beyond some bittering hops, leaving a slightly floral but vegetal finish. An okay beer for a local brewpub, but not quite up to the standard of most pale ales in distribution. Light bodied, creamy, lots of smooth bubbles. A simple beer, but not really in a good way. This needs some more aroma hopping or some other type of complexity. Long floral/vegetal finishing damages drinkability. Unless one is dying to try a new pale ale, I would not recommend this.
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);4;3.5;4;3.5;4;1249866208;d0ggnate;A: Pours a cloudy orange with a crisp white two finger head layer. S: Slightly citrusy with a bit of hops here, too. T: Malty and hoppy, but neither overpowers. Very well balanced. M: Calm and balanced flavors. D: This would be a great beer for a hot summer day. Nothing wild, but simply a good beer.
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);4;3.5;3.5;4;4.5;1249847121;babyhobbes;Received this can through Beer Powerball. I am really sorry that I don't know who sent it, my brother is keeping those records, but THANK YOU!! Pours with a nice half centimeter white fluffy head on a glass of dark straw-colored beer. Smells of citrusy hoppy goodness and oddly, a little like soap. Mouthfeel is very pleasant as is taste. This is a nice drinking beer. It's not blow you away with over-the-top flavor. It's a well-balanced, highly drinkable and enjoyable brew. I'm glad to have gotten the chance to try it.
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);4;3.5;4;4;4.5;1249556277;mdagnew;355ml can bought from Beersofeurope.com... Poured a golden yellow colour with a slight haze... White head poured fairly thick and foamy then faded to decent light covering... light carbonation... good sticky lacing lines cling to the glass... Aroma - Light maltiness mixed with a good dose of citrusy and peppery hops, pine, tart fruits (grapefruit, lemons, apples), very floral, quite grassy, faint honey sweetness, light breadiness, some sea salt... Taste - Good grassy and citrus hop bitterness, light pine, tart fruits (grapefruits, apples), light sweet biscuit malts, peppery, some salty notes, floral and perfumed... Feel - Quite smooth with a little bite underneath... light / medium body. Very, very quaffable and refreshing... Overall - A excellent, straightforward, hoppy APA... recommended...
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);4.5;3.5;4;4;4;1249347819;mikesgroove;I received this one in a BIF recently and it was the first thing I grabbed out of the fridge when I got home on Friday. Served cold and poured into a pint glass, this one was consumed on 07/31/2009. Appearance - One of the best pours from a pale ale you could possibly ask for. Seriously. Big head of white foam on top that barely falls back down to earth. Wonderful clear amber color that really just looks the part perfectly. Lots of carbonation creeping up the glass throughout And a really nice coating of spider like webbing. Smell - Aroma is lighter then I would have thought. Nice light grains, a touch of piney hops. As it warms a bit of citrus starts to come though, but again, lighter then I would have thought. Taste - Crisp, clean, the first sip has a biting touch to it as the pine and citrus start to roll through. Nice grains come in mid palate and then it rolls right back into a nice and dry bitter finish. Clean aftertaste leaves you to come back and look for a bit more. Feel - Light, airy and well carbonated. I had no issue at all with going forward with this one. The feel matched the overall experience very nicely. Drinkability - Session able, very nice and clean and easy drinking. Again had really no issue at all with putting this one away. Overall - Solid. Nothing earth shattering here but very solid. I would not mind at all grabbing a six pack and heading to the beach. Really very well done.
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);4;3.5;4;4;4;1248223105;hdofu;Orangeish with a peach head. Smell was hoppy. Taste was hoppy, not alot else going on. Not exciting but not boring either. It was easy to swallow but not alot else. Its something I could drink a few of. Good if you want a session beer but don't want a strong flavor.
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);3.5;4;3.5;4;3.5;1248142715;argock;Poured from 12oz can into a clear pint glass. No freshness date. Single purchased at Wine Warehouse (Charlottesville, VA) for $2.15. A: Honey-orange with solid 2-finger ivory head with decent retention and only a crown of lace. S: Plenty of hops in this one with above-average pale malt backbone with leafy and grapefruit aromas dominating. T: The flavor is good but a touch flat for the style, owing mainly to the lack of character in the maltload. The malt component is not quite sweet or roasted enough, which leaves a somewhat bland quality to this aspect. The hops are highly bitter and pretty harsh: a little more floral and citrus character would blend better with the ambiguous malting. Motwithstanding, this is an above-average APA without a doubt. M: Feel is a little thin for the style, although not far off with a medium-light body. Carbonation is a bit too short in supply. The aftertaste is very long with bitter and leafy hops notes persisting. D: A pretty good APA with a big price tag relatively. Solid and highly bitter for the style and could use a little more finesse. Still, enjoyable and didn't last long.
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);4;4;3.5;3.5;3.5;1247611689;Seanibus;I wish the flavor bore out the strength of the aroma, which it does not, but still not a bad beer. Pours a startling straw yellow with a smallish head that falls to nice lacing. The aroma is the strong point - assertively grainy with a crisp hop aroma, mostly grassy with a little flower. I really looked forward to tasting this beer. But it was weaker than I might have hoped, with less of a malt backbone that the aroma suggested and more emphasis on the flowery side of hop character. The bitterness rests, curiously, mostly on the foretaste, with relatively little clinging to the back. The mouthfeel is quite thin, almost insubstantial. This is a decent beer, but nothing to get excited about.
Caldera Pale Ale;25414;1075;5.50;American Pale Ale (APA);4.5;4;4.5;4;5;1246913078;GratefulBeerGuy;I'm really enjoying the variety of quality brews in a CAN i'm finding here in Northern California! this was reviewed while camping at Castle lake campgrounds in shasta city...i think. Ooooh yeah, cracking open a can sounds good!! a thick, solid and rocky -white head stands proud like Mt. shasta itself over a bright plae golden liquid, much like the N.Cali sunsets. Retention is amazing, it's not going anywhere anytime soon. The nose is just bursting with hoppy cascade aroma's!! Sweet fruits, musty herbs, wheat and corn and light but sweet malt. This all cascade beauty has a great aroma. The hoppy flavor's here are deep and very complex, cascade hoppiness all in my face. Light and very, very crispy feel is exciting and spot-on for the style. crisp with a creamy smooth finish from the beastie foam still clumping it's way down slow. The cascade hops provide a gentle fruitiness and perfect dry-herbal and earthy complexity. I havn't been this excited for a Pale ale since my very first Sierra Nevada!!(circa 1996) This pale ale in a can has made my day, and I'm camping in one of the most pristine locations I've ever been too. This is simply one of, if not THE best Pale ale i've ever had. Bring on the cans!!!
beer/name: Sausa Weizen
beer/beerId: 47986
beer/brewerId: 10325
beer/ABV: 5.00
beer/style: Hefeweizen
review/appearance: 2.5
review/aroma: 2
review/palate: 1.5
review/taste: 1.5
review/overall: 1.5
review/time: 1234817823
review/profileName: stcules
review/text: A lot of foam. But a lot. In the smell some banana, and then lactic and tart. Not a good start. Quite dark orange in color, with a lively carbonation (now visible, under the foam). Again tending to lactic sourness. Same for the taste. With some yeast and banana.
beer/name: Red Moon
beer/beerId: 48213
beer/brewerId: 10325
beer/ABV: 6.20
beer/style: English Strong Ale
review/appearance: 3
review/aroma: 2.5
review/palate: 3
review/taste: 3
review/overall: 3
review/time: 1235915097
review/profileName: stcules
review/text: Dark red color, light beige foam, average. In the smell malt and caramel, not really light. Again malt and caramel in the taste, not bad in the end. Maybe a note of honey in teh back, and a light fruitiness. Average body. In the aftertaste a light bitterness, with the malt and red fruit. Nothing exceptional, but not bad, drinkable beer.
beer/name: Black Horse Black Beer
beer/beerId: 48215
beer/brewerId: 10325
beer/ABV: 6.50
beer/style: Foreign / Export Stout
review/appearance: 3
review/aroma: 2.5
review/palate: 3
review/taste: 3
review/overall: 3
review/time: 1235916604
review/profileName: stcules
review/text: Almost totally black. Beige foam, quite compact, not bad. Light smell, just a bit of roast, and some hop. A bit too light. The taste is light oo, and drinkable, with some malt, roast, hints of coffee. Nothing exceptional, but after all drinkable and pleasant. Light to average body. In the aftertaste some dust, somr roast, hint of caramel, and a bit of bitterness. No defect, drinkable, not bad.
beer/name: Sausa Pils
beer/beerId: 47969
beer/brewerId: 10325
beer/ABV: 5.00
beer/style: German Pilsener
review/appearance: 3.5
review/aroma: 3
review/palate: 2.5
review/taste: 3
review/overall: 3
review/time: 1234725145
review/profileName: stcules
review/text: Golden yellow color. White, compact foam, quite creamy. Good appearance. Fresh smell, with good hop. Quite dry, with a good grassy note. Hay. Fresh and pleasant. More sweet in the mouth, with honey. The hop comes back in the end, and in the aftertaste. Not bad, but a bit too sweet for a pils. In the end some vanilla and camomile note. In the aftertaste, too. Though the hop, a bit too sweet. Honest.
beer/name: Cauldron DIPA
beer/beerId: 64883
beer/brewerId: 1075
beer/ABV: 7.70
beer/style: American Double / Imperial IPA
review/appearance: 4
review/aroma: 4.5
review/palate: 4
review/taste: 4.5
review/overall: 4
review/time: 1293735206
review/profileName: johnmichaelsen
review/text: According to the website, the style for the Caldera Cauldron changes every year. The current release is a DIPA, which frankly is the only cauldron I'm familiar with (it was an IPA/DIPA the last time I ordered a cauldron at the horsebrass several years back). In any event... at the Horse Brass yesterday. The beer pours an orange copper color with good head retention and lacing. The nose is all hoppy IPA goodness, showcasing a huge aroma of dry citrus, pine and sandlewood. The flavor profile replicates the nose pretty closely in this West Coast all the way DIPA. This DIPA is not for the faint of heart and is a bit much even for a hophead like myslf. The finish is quite dry and hoppy, and there's barely enough sweet malt to balance and hold up the avalanche of hoppy bitterness in this beer. Mouthfeel is actually fairly light, with a long, persistentely bitter finish. Drinkability is good, with the alcohol barely noticeable in this well crafted beer. Still, this beer is so hugely hoppy/bitter, it's really hard for me to imagine ordering more than a single glass. Regardless, this is a very impressive beer from the folks at Caldera.
beer/name: Caldera Ginger Beer
beer/beerId: 52159
beer/brewerId: 1075
beer/ABV: 4.70
beer/style: Herbed / Spiced Beer
review/appearance: 3.5
review/aroma: 3.5
review/palate: 3
review/taste: 3.5
review/overall: 3
review/time: 1325524659
review/profileName: oline73
review/text: Poured from the bottle into a Chimay goblet. Appearance: Pours a slightly cloudy yellow/orange color with a half finger of fluffy white head. The head fades to a small layer on top of the pour. Smell: Very light and crisp. I'm definitely picking up the ginger, but it's not overly powerful. There is a slight sweetness from the malt as well. Taste: Very light and refreshing. The ginger shows up right away and then fades towards the finish of the sip. The finish is malty and bread like. Mouthfeel: The body is on the thin side with smooth carbonation and a very dry finish. Overall: This is a light and refreshing beer, but nothing spectacular. The amount of ginger is nice, but I would have liked to have more going on.
beer/name: Caldera Ginger Beer
beer/beerId: 52159
beer/brewerId: 1075
beer/ABV: 4.70
beer/style: Herbed / Spiced Beer
review/appearance: 3.5
review/aroma: 3.5
review/palate: 4
review/taste: 4
review/overall: 3.5
review/time: 1318991115
review/profileName: Reidrover
review/text: 22 oz bottle from "Lifesource" Salem. $3.95 Nice golden clear beer body with a nice sized frothy/creamy white head. Ok aromas..mainlly a bit of ginger speice and some bready malt..simple nice Taste very nice indeed..nice spicy ginger backed with slightly caramel maltiness..simple again but i like . Liked the mouthfeel of this one..very forward carbonation which helps the ginger effect and a lingering ginger in the after taste. Overall a simple ginger brew .I liked it
beer/name: Caldera Ginger Beer
beer/beerId: 52159
beer/brewerId: 1075
beer/ABV: 4.70
beer/style: Herbed / Spiced Beer
review/appearance: 3.5
review/aroma: 2.5
review/palate: 2
review/taste: 3.5
review/overall: 3
review/time: 1306276018
review/profileName: alpinebryant
review/text: Bottle says "Malt beverage brewed with Ginger and ginger added" Sounds redundant to me, but lets move on. Pours a bud light yellow with a tiny white head of small bubbles. The beer is almost as clear as a glass of water with some food coloring in it. Aroma of light ginger, a very light malt aroma but primarily odorless on the malt side. I wouldn't be completely surprised if there were some adjuncts in here because of the lack of underlying malt flavors. Taste is of a light adjunct lager with a dosing of ginger. Not surprising there. This is a light session beer, good for the warmer days of spring / summer. Mouthfeel is extremely light, high carbonation. Overall decent. This would be great if you were drinking beers on draft at the bar with some friends just hanging out. I wouldn't necessarily seek it out though to drink out of a bottle.
beer/name: Caldera Ginger Beer
beer/beerId: 52159
beer/brewerId: 1075
beer/ABV: 4.70
beer/style: Herbed / Spiced Beer
review/appearance: 3.5
review/aroma: 3
review/palate: 3.5
review/taste: 4
review/overall: 4
review/time: 1290454503
review/profileName: LordAdmNelson
review/text: I'm not sure why I picked this up... I like ginger, and it was reasonably cheap compared to the other beers I was looking at. Pours a pale golden color with smallish head. Nose is largely uneventful, some ginger in there, a bit of pear, but mainly normal lager. Taste is pretty good, bringing a bit more of the ginger to the fore. MF was a bit fizzy, not terrible though. Easy drinker, I had no problem finishing the bomber. Interesting, but I probably won't get it again.
beer/name: Caldera Ginger Beer
beer/beerId: 52159
beer/brewerId: 1075
beer/ABV: 4.70
beer/style: Herbed / Spiced Beer
review/appearance: 5
review/aroma: 3.5
review/palate: 4
review/taste: 4
review/overall: 4.5
review/time: 1285632924
review/profileName: augustgarage
review/text: Poured from a 22oz bomber into my Drie Fonteinen tumbler. Hazy titanium yellow body (which catches the shadows forming a beautiful mysterious gradient) with an incredibly dense pillow of magnolia cream. Heavy persistent head and rich creamy lacing. Pale malt, asian pear, and a hint of citrus in the nose. A vaguely tropical lager... Tastes very much like a well done APA, with a nice balance of pale malt and low hop bitterness. The ginger adds to the refreshing character, but isn't readily detectable at first (lacks any "bite"). Medium-dry finish - very clean and extremely quaffable. I can imagine hibiscus and beets working in small quantities, though I think they omitted those for this version... Light bodied, pillowy, smooth and moderately carbonated. Don't go into this expecting a ginger beer (despite its name) as it has little in common with that spicy soft drink. This is a wonderful session ale though, and worth seeking out if you are a fan of light yet flavorful lagers. Would obviously go perfectly with sushi.
beer/name: Caldera Ginger Beer
beer/beerId: 52159
beer/brewerId: 1075
beer/ABV: 4.70
beer/style: Herbed / Spiced Beer
review/appearance: 4
review/aroma: 5
review/palate: 4
review/taste: 4
review/overall: 5
review/time: 1283154365
review/profileName: MadeInOregon
review/text: OK, so the only reason I bought this while shopping at Whole Foods was because I've never had a "ginger beer" unless it was ginger ALE...and we all know that's not the kind of "beer" we're interested in on this site! I was very excited to try this one!... When poured out it looks like a cheapo macro lager at first sight, then the slowly fading head suggests otherwise. The body is crystal clear and is a very light straw color. The head is bright white and slowly dissipates, but is initially quite thick. Smell is adjuncty, but there are slight notes of honey and some kind of herby thing going on...ginger perhaps? Can't really tell. From the smell there is obviously something different about this beer though. It has a unique spicy smell to it and reminds me a lot of basil, not ginger. I really can't quite place everything that I smell, but it is a very nice aroma. Superb fragrance for this beer, though definitely not a "ginger beer" based on the smell. The taste is very unique also. It's kind of like a spiced pilsner or kolsch but the "spice" is kind of hard to identify. It does not taste like ginger. This beer actually reminds me a lot of Bison's Honey Basil ale. There is some definite astringent burn in the upper throat after swallowing that is no doubt from the ginger, but that is the only ginger I can detect with any certainty. It is only slightly hoppy and malty. This a very enjoyable, very drinkable beer (I could easily drink 2 22oz'ers) but I think it's failing in its claim to be a "ginger" beer because I don't smell it, can barely taste it, and can only really detect the ginger's physiological effects of a warm throat and stomach. So, rating this one is hard; I've never had a ginger beer so I don't really know what one ought to taste like...but then again I can't really tell if I'm tasting ginger here or the combination of other things. So confused. My recommendation to you Caldera folks: ADD MORE GINGER! There's obviously enough of a curiosity about this style to not hurt sales if it was strengthened. I for one could handle it.
beer/name: Caldera Ginger Beer
beer/beerId: 52159
beer/brewerId: 1075
beer/ABV: 4.70
beer/style: Herbed / Spiced Beer
review/appearance: 4
review/aroma: 4
review/palate: 3.5
review/taste: 4
review/overall: 4
review/time: 1277557990
review/profileName: rawthar
review/text: Notes from 6/24 A: Bright golden glowing beer in a moment of clarity with a lively white head of feathery fluff S: The ginger is definitely there, or am I smelling my Indian dinner? Almost cake-like in its malt aroma, sharply bready with a slight edge of sweetness T: Nice clear malty throat taste, reminds me of strands of complex sugars and grains, ginger is more subtle than I expected, more of an undertone than a backbone M: A refreshing light beer feel, like a pilsner or summer ale D: If this was a sixer instead of a double-deuce, I could see this being a fine picnic pounder Overall, pretty impressed for the particular style
beer/name: Caldera Ginger Beer
beer/beerId: 52159
beer/brewerId: 1075
beer/ABV: 4.70
beer/style: Herbed / Spiced Beer
review/appearance: 3
review/aroma: 4.5
review/palate: 2.5
review/taste: 3
review/overall: 4
review/time: 1275779250
review/profileName: Halcyondays
review/text: 22 oz. bomber, A: Pours a clear yellow with a mild white head, good retention. S: Great nose of ginger, honey, perfume. T: Rather light upfront, it reminds me of Lawnmower, with a hint of ale fruitiness/Kolsch-like almost. Good ginger honey notes on the back end, not taking over the beer in any way. The ginger flavour is clear, but I wanted it to come out a little more in the end. M: Very light-bodied, watery, light base beer for sure. D: An easy drinking spiced beer, this will offend no one, but there's not a complexity to this brew at all.
beer/name: Caldera Ginger Beer
beer/beerId: 52159
beer/brewerId: 1075
beer/ABV: 4.70
beer/style: Herbed / Spiced Beer
review/appearance: 3
review/aroma: 4
review/palate: 3
review/taste: 4
review/overall: 3.5
review/time: 1273109020
review/profileName: RangerClegg
review/text: Is it possible for a bottle to be a novelty product? I bought it cause it's the only bottle of Caldera I've ever seen, so I guess so. Stoked to be the first to review a beer! That's a lot of responsibility so I might as well give it a thorough review. Poured into my New Belgium Tulip. A - Clear golden color with a bright white 1" head that slowly fades to a ring around the top. Lacing is minimal, but still there and fighting to cling to the glass S - Smell is of ginger and honey. Very appealing. T - First hit is of ginger. Not too strong or biting but just the right amount. Fades to a sweetness on the tongue that is sort of perfect and then... a little bit of bite from the hops making their presence known. M - Medium bodied and full. A nice round beer for the summer. Not too heavy, definately not watery. Not very good at describing it other than it's good. D - I really like this beer and I could probably put 2 or 3 glasses away, so one bomber is enough for me. I think 2 bombers would be too much, but I could probably drink one and half, so I think I'll have to stick with the one. Overall this is a pretty good ginger beer. I think that for my money though, I'd rather buy Trade Route's Ginger Pale Ale. If you've never had a ginger beer, Pick it up.
beer/name: Caldera Oatmeal Stout
beer/beerId: 10789
beer/brewerId: 1075
beer/ABV: 7.20
beer/style: Oatmeal Stout
review/appearance: 2.5
review/aroma: 3
review/palate: 3
review/taste: 3
review/overall: 3
review/time: 1316025612
review/profileName: Beerandraiderfan
review/text: Brown in color, somewhere between a porter and a brown ale. Lacking in aroma, but no off stuff. Same with the taste, lacking flavor, complexity, just went with smoothness. No off flavors though, so I can't say this is bad, just unadventurous, especially for Caldera, whom I think is generally underrated. You really have to search to pull anything out of this in terms of the usual chocolate/coffee flavors, really, the only thing I can tell is that the oats did their job, because this is smooth and unoffensive. Other than that, extremely pedestrian.
beer/name: Caldera Oatmeal Stout
beer/beerId: 10789
beer/brewerId: 1075
beer/ABV: 7.20
beer/style: Oatmeal Stout
review/appearance: 2.5
review/aroma: 1.5
review/palate: 2.5
review/taste: 2
review/overall: 2
review/time: 1103502339
review/profileName: RedDiamond
review/text: Caldera presents yet another circumstance where the brewery does not operate a brewpub, doesnt bottle their beers, and is located 300 miles from my home. To review their beers I traveled to their hometown of Ashland, OR and drank at the Ashland Creek Bar and Grill. This may have been a mistake. Though I had other reasons to visit Ashland, its disappointing (to say the least) to travel 300 miles and be served a spoiled beer. Both the Oatmeal Stout and Ashland Amber were of poor quality at the Ashland Creek Bar and Grill. In the case of the Oatmeal Stout, a nice measure of cream and a wayward thread of mint were marred by a sulfuric smell and likely bacterial infection. Though I cant say for certain, my best guess is that the house tap lines were something other than sanitized. I will attempt to revisit and re-evaluate this beer. But for the time being, its important to ask a pertinent question about quality control. Caldera is a 10 bbl microbrewery in a small town. How much responsibility do they have towards assuring that taps serving their product in their hometown are kept reasonably clean and free of bacterial encroachment? My answer to this question is that the brewery does have some responsibility to assure quality pours in its own hometown. This is especially so when they operate no pub of their own. Not only does this effort protect the consumer from being served a spoiled beer, but the enforcement of quality control measures at the point of consumption simply makes good business sense. Till then, theres nothing I really care say about this beer other than to wish whoever pursues it greater luck than I had at Ashland Creek.
beer/name: Caldera OBF 15
beer/beerId: 12386
beer/brewerId: 1075
beer/ABV: 5.60
beer/style: American Pale Lager
review/appearance: 4
review/aroma: 3
review/palate: 4
review/taste: 4
review/overall: 4
review/time: 1062311123
review/profileName: beerguy101
review/text: More of a 'dry' than a lager, tasted at the 2002 Oregon Brewers Festival. Orange color, orange flavor in nose. Light malts and fairly aggressively hopped; yet it is not very bitter. Interesting taste, complex and subtle. Light yet flavorful. Mouthfeel is full and round. Finish is clean and smooth. Aftertaste is slightly bitter. Nice beer. Would be a great beer to sip during a hot summer day.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 3
review/aroma: 4.5
review/palate: 4
review/taste: 4.5
review/overall: 4.5
review/time: 1325478004
review/profileName: UCLABrewN84
review/text: Pours a murky light brown with a 1 inch fizzy tan head that settles to a film on the top of the beer. Small dots of lace slowly drip back into the remaining beer on the drink down. Smell is of smoked meat, smoked cheese, campfire smoke, etc. Taste is of smoked meat/cheese, campfire smoke, wood, and a slight cocoa/coffee flavor on the finish. The aftertaste is also cocoa/coffee with just a hint of the smoke flavors. This beer has a crisp level of carbonation with a bubbly mouthfeel. Overall this is a very good rauchbier from Caldera that has a bit of a different flavor than German rauchbiers.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4
review/palate: 3
review/taste: 4
review/overall: 4
review/time: 1325360812
review/profileName: zaphodchak
review/text: Faint sudsy head with some with some dissipating fine surface. Light ruddy brown. Some lace. Smokiness in the nose along with pickling vinegar (faint), and some slightly musty malt. Plenty of bitter, slightly tangy, tannic beech smoke. Traces of sweet toffee on the finish. Feel is standard, smooth, but went flat quite fast.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4.5
review/palate: 3.5
review/taste: 4
review/overall: 4
review/time: 1322506304
review/profileName: Tilley4
review/text: A new arrival to the West TN area... Pours quite a bit lighter than I was expecting. Almost like a brown ale? Good head retention though... Smoky bacon aromas upfront mesh with a sweet maltiness... This is definitely very smoky but not overpoweringly so... Its subtle at times and powerful at others on the nose... Like being in a smokehouse after the meat has already been removed... Very interesting... Sweet caramel malts surprise me as I thought the smoke would hit hard right off the bat... The smokiness here is beautifully done... Not a smoke bomb but rather the smoked meat flavors run parallel to the sweetness darting in and out, here and there... Very good example from Caldera here. Excellent use of the smoke with its subtleties...
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4.5
review/aroma: 5
review/palate: 4
review/taste: 4.5
review/overall: 4.5
review/time: 1320494397
review/profileName: mikedrinksbeer2
review/text: Sampled 10/30/11 - Transferring the notes. A ruby pour with a half finger, off white head. Opaque. Smells like bacon it's so smoky. Very much a wood smoked scent, great on an autumn night. The flavor is full but not overbearing, smoky with a hint of sweetness. I dig this a lot, will seek out other rauchbiers for some comparison.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4.5
review/palate: 4
review/taste: 4.5
review/overall: 4
review/time: 1320140421
review/profileName: dbmernin83
review/text: This is my first rauchbier. Pours a burnt amber. Good head. Holy smoked meat! This has huge beef jerky on the nose. Salty smoked meat goodness. Tastes about the same as it the nose. Wood, smoked meat, cured meat, soy sauce. This is delicious for the first 6-8oz, then it gets to be a little much. I imagine after having this a few times, you appreciate the flavors more. Maybe I should've picked a tamer rauchbier to be my first
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4.5
review/palate: 4
review/taste: 4.5
review/overall: 4.5
review/time: 1319847514
review/profileName: titosupertramp
review/text: A: Pours a rich, ruby color, clear. Maybe a finger of off-white head. Thin cap with thick ring of bubbles around the edge of the glass. Light lacing. S: Wow. Smoked meat balanced by caramel, bready sweetness. I wish they would make this smell into a cologne..no shit, I'd wear it to special occasions. T: Taste is equally as good. Smoked meat with just a hint of peet. The nice thing about this beer is the smoked characteristics don't overpower the rest of the beer. The caramel, bready malts hold up nicely and there seems to a slightly hoppy finish. M: A little on the light side, but it's still manages to be somewhat creamy. O: I had heard some good things about this beer and it certainly lived up to my expectations. It's a very well crafted beer where the smoke asserts itself, but doesn't drown out everything else. I'll pick this up again without a doubt.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 3.5
review/aroma: 5
review/palate: 3.5
review/taste: 5
review/overall: 5
review/time: 1318802642
review/profileName: optimator13
review/text: Pours a mahogany color, rich, with a tan head. a finger, didn't stick around. Holy smokes! This is one of the most smokiest beer I've ever had! BUT. It's balance and not one sided. Smoke, cured bacon, rich caramel malts. More smoke. Ok, maybe it one sided, but it's heavenly. Rich caramel malts and salty cured bacon strips. Bacon lover right here, so, I don't feel the need to go on. Lighter, but medium in body. feels fine. Nothing tremendous. Aroma and flavor alone are mouthwatering. Bravo. More please!!!
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4.5
review/palate: 4
review/taste: 4.5
review/overall: 4.5
review/time: 1318290101
review/profileName: Blakaeris
review/text: Pours light caramel brown with reddish highlights. The crisp white head doesn't hang around long, but quickly dissipates to a thin ring. Aroma is intense meaty smokyness. Underneath is a mild malty sweetness. Taste is really interesting. The smoked meat quality is retained, but there is also a generous earthy, woody character. Caramel and toffee really round things out. Finishes with a mildly dry cedar character. Mouthfeel is a chewy, medium body. A flavorful brew. Strong smokiness is tempered by the rich caramel malt qualities. A real winner that could bring the non-smoke lover around.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 5
review/palate: 4
review/taste: 4
review/overall: 4.5
review/time: 1318289482
review/profileName: bashiba
review/text: Poured a slightly cloudy deep amber/red color with a thin soap ring of head. The smell is amazing, big bacony smoked pork Rauch goodness. The taste follows the flavors nicely with a big smoked malt flavor with a nice bit of underlying sweetness, very pork like and very flavorful. Has a nice light bitterness in the finish that helps even it out very well. The mouthfeel is very slick and oily. Great Rauchbier!
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 3.5
review/aroma: 4.5
review/palate: 4
review/taste: 4.5
review/overall: 4.5
review/time: 1316405909
review/profileName: Klym
review/text: Big thanks to N2168 for knocking this off my wants. Poured into a stone nonic and shared with my buddy Ryan. This was quite delicious. The pour made it seem a little lacking in carbonation, and while indeed it was light in carbonation I think it would have been awkward if it had been heavier considering the taste profile. This beer does such a good job of hitting the sweet and savory side of smoke. Nice big campfire smoke smell and taste without any roughness to it, with a nice smoked bacon savory sweetness. This is easy to drink and just downright delicious, would love to have a keg of this by my desk.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4.5
review/palate: 4
review/taste: 4
review/overall: 4.5
review/time: 1315696563
review/profileName: flexabull
review/text: On tap last night at the Caldera Tap House. Pours a bright and clear brown color, with a small white head. Aromas are quite potent. Lots of interesting smoke notes here, smoked meat, charred wood, like a camp out in a glass. Very nice. Flavor is like the nose, but toned down just a bit. Light caramel, bready, and slightly sweet up front. Beer then settles Into a smoke house flavor, hints of charred wood, and jerky. Mouthfeel is good, full, smooth, but not heavy at all. Overall, this is a really well made smoked lager. The nose is wonderfull. But the beer turns out to be plenty drinkable, I usually am a one and done with smoked beers, not this one. Another great offering from Caldera.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4.5
review/palate: 4
review/taste: 5
review/overall: 5
review/time: 1315014054
review/profileName: Bung
review/text: 22 oz. Think I picked this up in Chicago Binny's Oak Park. Solid amber/brown pour, half finger of off white head disappated to a ring, but lasted. Smoked malt, peat, canadian bacon and some malty caramel. Starting out real well. Taste, solid dose of smoked ham, bacon, peat and a woodiness. Caramelly malt body is there, almost some faint raisin or apple cider, then finishes with solid bbq. The real deal, far far and away the best American version I've had of this style. So few try this style, even less accomplish the task. Lighter side of medium bodied. Coats well, goes down smooth, no alcohol. 7.4 is a little larger than some for the style, but it doesn't show itself. Best brew I've had in a while. First I've had from this brewery, if their others are even close to as good as this I won't be disapointed.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4.5
review/aroma: 4
review/palate: 4
review/taste: 4
review/overall: 4
review/time: 1314752229
review/profileName: oberon
review/text: Poured into a 1/2 liter stein a deep rich amber/bronze with a fluffy one finger head that took its time fading.Sweet smoke,brown,sugar,a bit of alcohol in the nose,mellow and sweetish,I found it appetizing.Cherry wood sweetness and light peppery spice in the nose,its gentle sweet smoke instead of in your face,mellow but assertive enough.A real nice smoked bock beer,I will grab a few of these this fall while eating alot of smoked meat off my smoker.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4.5
review/palate: 4
review/taste: 4
review/overall: 4.5
review/time: 1312403394
review/profileName: t420o
review/text: A- Semi aggressive pour produces a 1-1/2 finger very light brown head that rests atop a beautiful deep copper colored beer with nice clarity. Nicve lacing. S- Very similar to a smoked porter but more smoke. The smoke smell is beautiful. It smells like a campfire and the cherry wood is definitely present. Excellent smelling beer. T- WOW! They were not kidding on the bottle when they said it has an intense smoke flavor. It is excellent and I could see some folks that the smoke is too in-your-face, but I love smoked beers and I love this one. This is as smoked wood forward as I've ever had. It's pretty much smoky wood, a slight malt sweetness, and finishes woody and smokey again. This is a perfect fall beer. M- Nice smooth mouthfeel with good carbonation. O- Not too complex because of the intense smoke taste but it works excellent in this beer. I will definitely be picking this up again.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4
review/palate: 4
review/taste: 4
review/overall: 4
review/time: 1312162337
review/profileName: DarthKostrizer
review/text: Look: Burnt orange in color with 1/4 inch head and no retention but did have some lacing Smell: This beer smells like a campfire in a bottle also reminds me of burnt oak chips or smoked salmon Taste: The flavor is this beer is quite unique. The smokiness is there in abundance and is pretty much just liquid smoke. Again the taste does follow suite with the noise there is a big smoked salmon flavor Mouthfeel: Medium body and medium carbonation Overall: If you love the idea of smoked anything actually you will love this beer. It is hands down one of the most smoky beers I have had to the point where it almost looses balance like say Alaskan smoked porter or Ass kisser smoked porter. However if you are into smoked beers this one is a must try
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 3
review/aroma: 4
review/palate: 4
review/taste: 4
review/overall: 4
review/time: 1312070406
review/profileName: MrVonzipper
review/text: Bottleshare from Darthkostrizer with BHOBS and Alucard4 Pours a hazy reddish brown with a very quick dissipating bubbly head. No retention obviously. Holy shit. Smells exactly like uncooked applewood smoked bacon and/or smoked salmon(not fishy). Very nice yet strong smoke. Tastes just like it smells. Very strong different smoky flavor but Good. Good carbonation. Smooth and Medium bodied. Overall at some point in trying this beer You Will Say Holy Shit! It is Unlike any any beer I've had and any smoked beer for that matter. Its very interesting but Good. Although it very hard to drink alot of it. Definitely a bottleshare.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 3
review/aroma: 4.5
review/palate: 2
review/taste: 3
review/overall: 3
review/time: 1311558510
review/profileName: Beerandraiderfan
review/text: Amber to yeloowcolored, was expecting darker, kind of even had a good degree of clarity to it. Holy cherry wood campfire smoke! This smelled just like you were out in the woods. Whoa, I could only take a small sip at first, massive liquid smoke feeling in the mouthfeel. Ugh. Its not so much as 'bad' as opposed to 'challenging'. I must admit, I could not even finish a taster of it. This is the most intense smoked beer I've ever come across, by far. I mean, beer geek bacon was a walk in the park compared to this. I could smell it all day. As far as drinking it, I'm cool with 1oz at a time, its that intense. If you like smoked beers, then check this out. If not, stay away. I kind of like them, trying to get into them more, so I'd try it again next time, but for now, I'm not worthy.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4.5
review/aroma: 4.5
review/palate: 4
review/taste: 3.5
review/overall: 4
review/time: 1309310508
review/profileName: TheWhiskerReview
review/text: Pours a brilliant black with ruby tones and a 1-finger tan head. Weak retention and lace, as expected from such a malty brew. The nose is a smoky, malty blast of barbequed pulled pork, woodsmoke and brown sugar with undertones of baked apples and peaches. Nothing over-the-top here- good balance and elegance in the aromas. And I dunno if it's just me and my mental associations, but I could swear I smelled the BBQ sauce in this too. The palate, much like the nose, is hugely smoky- more bbq and toffee flavors- with a medium-body and a slight creaminess from the malt. The hoppiness is mild while the smoke, naturally, is what lingers on the nice finish. A wonderful effort overall. I wouldn't go so far as to say world class, but the brew does have a nice bit of elegance which always gets more points from me. And the smokiness carries a lot of power without being too heavy.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4.5
review/aroma: 3.5
review/palate: 4
review/taste: 3.5
review/overall: 3.5
review/time: 1307850875
review/profileName: Elimination
review/text: I have been thinking of picking up a bottle of this for a while pours a deep deep red, glowing, standing out a lot smell of slight smoke, peat, a bit of cherry, bbq Taste is mostly peated malt smoke, a lot of it...i was expecting more smokey, not peated. still a bit of darker, roasted fruits, a bit of burnt sugar, some peanut but overall makes it pretty unique. Mouthfeel is really smooth, lower carbed tickles the tongue just right, goes down well Overall its not bad, but as far as a rauch, feels like to much of that peated taste, dont know if I would pick it amongst other smoked beers.
beer/name: Rauch Ür Bock
beer/beerId: 58046
beer/brewerId: 1075
beer/ABV: 7.40
beer/style: Rauchbier
review/appearance: 4
review/aroma: 4
review/palate: 4.5
review/taste: 4.5
review/overall: 4.5
review/time: 1306128988
review/profileName: DoubleJ
review/text: "Warning, this beer has an intense smoke flavor." Warning...'cuz the flavor may cause me to overdose? I'll leave it at that and hope I don't O.D. off this 22 ounce bottle. On to the beer: The chestnut colored body is a looker in the stange glass. On top, the head has a beige color, a somewhat creamy texture, several groupings of lace sticking around and retention. The rauch part is done extremely well; mouth-watering jerkied meats stand out above with a little sweetness and a kiss of leafy hop. There's a lot of meat on the bones of this beer. Loads and loads and maltiness and medium smokiness make this a winner. The two run in sperate stages and never cross into each other's territory, which in this case I adore. Its got the smokiness that I would find in a summer sausage. On the malty side, there's loads of caramel. Little notes of ash give me the impression that I'm at a campfire. Hints of brown sugar. Alcohol slowly gets noticed, but in a good way; here it brings notes of raisin. There is a moderate hoppiness that can be sensed for a brief second, catch it before the smoke and malt beat it down. On the fuller side in terms of mouthfeel, quite smooth with the bubbles very small yet enough to be felt. If I hadn't stuffed myself with Chinese food earlier in the night, I may have been more tempted to overdose on Rauch Ur Bock. Only kidding, I have a good idea when to stop. Warning, you may be temped buy more bottles after you try your first. In short, superb.
//Import BeerAdvocate
//On my Macbook the queries take about 38secs/iteration
//so 38*15 = approx 570secs = 9.5mins - APPROXIMATELY
//put all the indexes in place
create index on :Beer(name);
create index on :Style(name);
create index on :Brewery(id);
create index on :Profile(name);
create constraint on (b:Beer) assert b.id is unique;
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba1.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba1.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba1.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba1.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add an Anonymous profile
merge (p:Profile {name:"Anonymous"});
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba1.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// generate the META-graph
// run this after the FIRST iteration of the queries above
// DO NOT run after the last iteration - it would be very slow and not add anything!
MATCH (a)-[r]->(b)
WITH labels(a) AS a_labels,type(r) AS rel_type,labels(b) AS b_labels
UNWIND a_labels as l
UNWIND b_labels as l2
MERGE (a:Meta_Node {name:l})
MERGE (b:Meta_Node {name:l2})
MERGE (a)-[:META_RELATIONSHIP {name:rel_type}]->(b)
RETURN distinct l as first_node, rel_type as connected_by, l2 as second_node
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba2.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba2.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba2.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba2.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba2.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba3.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba3.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba3.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba3.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba3.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba4.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba4.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba4.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba4.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba4.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba5.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba5.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba5.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba5.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba5.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba6.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba6.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba6.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba6.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba6.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba7.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba8.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba8.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba8.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba8.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba8.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba9.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba9.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba9.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba9.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba9.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba10.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba10.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba10.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba10.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba10.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba11.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba11.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba11.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba11.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba11.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba12.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba12.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba12.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba12.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba12.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba13.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba13.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba13.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba13.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba13.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba14.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba14.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba14.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba14.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba14.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
//import beers, breweries, styles WITH ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is not null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
// takes 14s
//import beers, breweries, styles WITHOUT ABV
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.beer_ABV is null
merge (b:Beer {id: toInt(csv.beer_beerId)}) ON CREATE SET b.name=csv.beer_name, b.ABV=csv.beer_ABV
merge (s:Style {name: csv.beer_style})
merge (br:Brewery {id: toInt(csv.beer_brewerId)})
merge (b)-[:HAS_STYLE]->(s)
merge (b)<-[:BREWS]-(br);
//add the reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
merge (p:Profile {name: csv.review_profileName});
// takes 16s
//the query below is NO LONGER PROBLEMATIC
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is not null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
// takes 13s
//add the anonymous reviews
using periodic commit
load csv with headers from "file:/Users/rvanbruggen/Dropbox/Neo Technology/Demo/BEER/BeerAdvocate/real/ba15.csv" as csv fieldterminator ';'
with csv where csv.review_profileName is null
create (r:Review {taste: toFloat(csv.review_taste), appearance: toFloat(csv.review_appearance), text: csv.review_text, time: toInt(csv.review_time), aroma: toFloat(csv.review_aroma), palate: toFloat(csv.review_palate), overall: toFloat(csv.review_overall)})
with r,csv
match (b:Beer {name: csv.beer_name})
match (p:Profile {name: csv.review_profileName})
create (p)-[:CREATES_REVIEW]->(r)
create (r)-[:REVIEW_COVERS]->(b);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.