Netherlands: Software

Introductie van Micorosoft SQL Server 2016

Issue link: http://hub-nl.insight.com/i/692679

Contents of this Issue

Navigation

Page 107 of 212

95 C H A P T E R 5 | Broader data access [TimeStamp] DATETIME NOT NULL, [EngineTemperature] int NOT NULL, [TirePressure] int NOT NULL ) WITH (LOCATION='/rawcarevents/car_sensor_data.tbl', DATA_SOURCE = HadoopStorage, FILE_FORMAT = MyDelimitedTextFileFormat, REJECT_TYPE = VALUE, REJECT_VALUE = 0 ); Note For more information about creating an external table, see "CREATE EXTERNAL TABLE (Transact-SQL)" at https://msdn.microsoft.com/en-us/library/dn935021.aspx. Viewing PolyBase objects in SSMS After you create the PolyBase objects, you can view them in SSMS in Object Explorer. Expand the database folder, expand Tables, and then expand External Tables to view your external tables, as shown in Figure 5-10. Your external data sources and external file formats are visible in the respective folders in the External Resources folder for your database. Figure 5-10: Viewing external resources in SSMS. Using T-SQL with PolyBase objects After you create external tables, your data is accessible by using standard T-SQL queries. Any application or reporting tool that can access SQL Server can use PolyBase by referencing an external table in the same way as for any relational table stored in SQL Server, without requiring special configuration in the tool or special knowledge from your users. Not only can you write queries to retrieve data from external tables, you can also join the unstructured data with structured data stored in SQL Server, as shown in Example 5-36. If you are using data stored in Hadoop, you can add OPTION (FORCE EXTERNALPUSHDOWN) or OPTION (DISABLE

Articles in this issue

Links on this page

Archives of this issue

view archives of Netherlands: Software - Introductie van Micorosoft SQL Server 2016