In the last few days I needed to build a modal which loads a iFrame inside to display a third party content, and the target devices includes desktops, mobiles and tablets. There is no problems to display the content on desktop, scrolling works, modal popup works. However, the frustration comes …
Do you ever need to work with Time Zone info in your code? If no, you are lucky, if yes, then you might have encountered the strange interpretations of “GMT+11” in PHP. In common sense, either “UTC+11” or “GMT+11” would mean the GMT time + 11 hours, which will be …
Hive supports MAP data type, to defined it in a table, use the following code: This works fine if you only need to insert data into this table using hive UDFs to convert data into MAP, but it will be tricky if you want to load the data from a …
Hive supports array type columns so that you can store a list of values for a row all inside a single column, and better yet can still be queried. This is particularly useful to me in order to reduce the number of data rows in our database. Our original “answer” …
Sometimes the Hive query you want to write could not be expressed easily using the Hive built-in functions. By writing a user-defined function (UDF), Hive makes it easy to plug in your own processing code and invoke it from a Hive query. There are three types of user-defined functions you …
My new Snowflake Blog is now live. I will not be updating this blog anymore but will continue with new contents in the Snowflake world!