ImageExtractor (U-SQL)

Summary

The ImageExtractor function from the ImageCommon assembly is used to extract data from images that will be consumed by other cognitive functions. The current maximum size of a row is 4 MB so you will need to use images less than 4 MB in size when using ImageExtractor.

Examples

• The examples can be executed in Visual Studio with the Azure Data Lake Tools plug-in.
• Ensure you have installed the cognitive assemblies, see Registering Cognitive Extensions in U-SQL for more information.
• The scripts can be executed locally if you first download the assemblies locally, see Enabling U-SQL Advanced Analytics for Local Execution for more information. An Azure subscription and Azure Data Lake Analytics account is not needed when executed locally.
• You will need images accessible to you ADLA or Local account.

Load images to a rowset variable

REFERENCE ASSEMBLY ImageCommon;   

@images =
    EXTRACT FileName string, 
            ImgData byte[]
    FROM @"/Samples/Images/{FileName}.jpg"
    USING new Cognition.Vision.ImageExtractor();

@result = 
    SELECT FileName FROM @images;

OUTPUT @result 
TO "/ReferenceGuide/Cognition/Vision/ImageExtractor_rv.txt" 
USING Outputters.Tsv();

Load images to a table
This table will be referenced in various cognitive examples

REFERENCE ASSEMBLY ImageCommon;   

DROP TABLE IF EXISTS dbo.myImages;
CREATE TABLE dbo.myImages (
       INDEX clx_FileName CLUSTERED(FileName ASC) 
       DISTRIBUTED BY HASH (FileName)
) AS EXTRACT FileName   string,
            ImgData     byte[]
    FROM @"/Samples/Images/{FileName}.jpg"
    USING new Cognition.Vision.ImageExtractor();

See Also

• Built-in U-SQL System Objects and Extensions
• Extending U-SQL Expressions with User-Code
• Cognitive Capabilities in U-SQL