SQLPASS Focus Group: BI on Big Data

We’re only a week away from the SQL PASS 2012 Summit!  There are a ton of great sessions and of course there will be plenty of fun and karaoke during / after the sessions all week long! An cool aspect of the PASS summit are the Focus Group with SQL Server experts.  Check out the full session list at SQL PASS Summit 2012 Focus Groups. One focus group that is particularly dear to me is the BI on Big Data Focus Group: BI on Big Data Wed, Nov 7, 1:30pm – 3:00pm – Room 304 Learn and provide feedback on…

Rate this:

Oh where, oh where did my S3N go? (in Windows Azure HDInsight) Oh where, Oh where, can it be?!

As noted in my previous post Connecting Hadoop on Azure to your Amazon S3 Blob storage, you could easily setup HDInsight Azure to go against your Amazon S3 / S3N storage.  With the updates to HDInsight, you’ll notice that Manage Cluster dialog no longer includes the quick access to Set up S3. Yet, there are times where you may want to connect your HDInsight cluster to access your S3 storage.  Note, this can be a tad expensive due to transfer costs. To get S3 setup on your Hadoop cluster, from the HDInsight dashboard click on the Remote Desktop tile so…

Rate this:

Travel Tuesday: Sagrada Famila

For this Travel Tuesday post – allow me to share some personal photos from the beautiful Basilica I Temple Expiatori de la Sagrada Familia in Barcelona, Catalonia, Spain.  This is one of Antoni Gaudi’s most amazing and famous works merging Gothic, Catholicism, and  Art Nouveau.  For more information, check out wikipedia: http://en.wikipedia.org/wiki/Sagrada_Fam%C3%ADlia Though it is an incomplete work of art that will take decades to complete, it is well worth visiting and touring this UNESCO site.  Important biblical events are depicted all throughout on the exterior walls of the basilica. It is a testament to Gaudi’s vision to have drawn…

Rate this:

Foodie Friday: Joi’s Seafood Restaurant–Dim Sum in Bellevue

I’m a big fan of dim sum and in the Bellevue area, I am a frequent visitor of Top Gun Seafood Restaurant.  But when I heard dim sum right in downtown Bellevue, I have to admit I was skeptical at first.  If you look at the Yelp reviews for the restaurant (http://www.yelp.com/biz/jois-chinese-seafood-restaurant-bellevue-2) – it’s mixed at best – though the more recent reviews tend to be positive. I will definitely agree with the more recent reviews as the Dim Sum is quite good and even better they do not use a lot of MSG.  It is very common to go…

Rate this:

HiveODBC error message “..expected data length is 334…”

One of the odd HiveODBC error messages that I recently encountered on a project is that when I am extracting data from my Hive/Hadoop cluster using the HiveODBC driver, I end up getting an error message similar to: OLE DB provider ‘MSDASQL’ for linked server ‘[MyHadoopCluster]’ returned data that does not match expected data length for column ‘[MSDASQL].error_message’. The (maximum) expected data length is 334, while the returned data length is 387. In this case, the error message was generated from connecting my SQL Server to a Mac OSX Hadoop 1.0.1 cluster running Hive 0.8.1 using the HiveODBC driver (why…

Rate this:

Padding zero-length string data with HiveODBC

One of the more esoteric error messages that you may receive from the HiveODBC driver connection is: SQL_ERROR Failed to get data for column zu When connecting to Hive using the HiveODBC driver using a linked server connection, the full error message looks something like: OLE DB provider “MSDASQL” for linked server “MySQLHive” returned message “SQL_ERROR Failed to get data for column zu”. OLE DB provider “MSDASQL” for linked server “MySQLHive” returned message “SQL_ERROR get signed long int data failed for column 9. Column index out of bounds.”. OLE DB provider “MSDASQL” for linked server “MySQLHive” returned message “Option value…

Rate this:

Foodie Friday:肉圓 (Ba-Wan) at 林員肉圓 near Banciao Station, Taipei

As some of you may have known, I had the opportunity to travel and stay in Taiwan earlier in the year.  Amazingly, I’m still super behind in my my Foodie Friday blog posts of great places to eat. . For today’s post, this is a great local Taiwanese dish known as 肉圓 or Ba-Wan.  It is a Taiwanese snack food that literally means “meat sphere”.  In this case, this is a 肉圓 that is made of pork within rice-paper translucent dough.  The sauce is savory, the meat is quite fatty (in a good way), served nice and hot!  For more…

Rate this: