Big SQL, a SQL interface introduced in InfoSphere® BigInsights™, offers many useful extended data types. In general, a data type defines the set of properties for values being represented, and these properties dictate how the values are treated. Big SQL supports a rich set of data types, including extended data types that are not supported by Apache Hive. With data types supported by Big SQL, it’s easier to represent and process semi-structured data. Using the code samples and queries included, learn how to use Big SQL complex data types in simple and nested form and how to create and implement these types in an application. As an added bonus, see how to use the Serializer Deserializer (SerDe) to work with JSON data.

Author: Neha Tomar

Link: http://www.ibm.com/developerworks/library/bd-bigsqldatatypes/index.html?ca=dat-

PDF: http://www.ibm.com/developerworks/library/bd-bigsqldatatypes/bd-bigsqldatatypes-pdf.pdf

Join The Discussion

Your email address will not be published. Required fields are marked *