Social
Recent Photos
Navigation
Tuesday
May222012

Zombies, Run!

I'm not a big fan of running. The last few weeks I've been running with Zombies, Run!. This has made running much more enjoyable.

The story in the game is a great distraction on a short or long run. I run with the zombie chases enabled which adds an extra level of excitement that keeps you on your toes listening for the "Zombies Detected" warning.

For now it is iPhone only, but it is coming to Android soon.

Sunday
Apr292012

Ladew Gardens

This weekend my mom is in town. On Saturday we visited Ladew Gardens north of Baltimore. It was a great opportunity to try out a little macro photography. Here are some of the best shots.

Sunday
Apr012012

Getting some pictures again

On a camping trip this weekend to Shenandoah national park I got some much needed photography practice. It was hardly fair out there. The deer are very tame. I was able to get very close for these shots. There are a few more shots up on Flickr.

Wednesday
Mar282012

Complex Counts in Hive

This came up on the Hive mailing list and I'm putting it here as a reminder to try it out.

Here's how to do complex count statements to simplify queries.

SELECT
    type
  , count(*)
  , count(DISTINCT u)
  , count(CASE WHEN plat=1 THEN u ELSE NULL)
  , count(DISTINCT CASE WHEN plat=1 THEN u ELSE NULL)
  , count(CASE WHEN (type=2 OR type=6) THEN u ELSE NULL)
  , count(DISTINCT CASE WHEN (type=2 OR type=6) THEN u ELSE NULL)
FROM
    t
WHERE
    dt in ("2012-1-12-02", "2012-1-12-03")
GROUP BY
    type
ORDER BY
    type
;
Wednesday
Mar072012

The New iPad

The retina display got me. I could ignore the faster processor and the nifty cover in the iPad 2 and stick with my first generation one. I did the same with the iPhone 3 and 3GS. I wasn't sure how much of a difference the retina display would make, but the iPhone 4 got me hooked. I'm looking forward to not being able to see the pixels on the new iPad.