none
Cannot install / load "ggplot2" from Sql Server 2016 RRS feed

  • Question

  • Hi All:

    I am just have a weird issue that I cannot load the package "ggplot2" while it works perfectly fine with all the others.

    It keep on saying there is no package call "ggplot2" while I definitely have one in the folder.  Your help will be really appreciated.

    Saturday, April 1, 2017 11:29 AM

Answers

  • Hi Johnny,

    You might want to refer to this post which posted similar question as yours - link.

    You can run the following statement in SSMS to find out where is the default library and make sure ggplot2 zip file is there in the folder.

    EXECUTE sp_execute_external_script  @language = N'R'
    , @script = N'OutputDataSet <- data.frame(.libPaths());'
    WITH RESULT SETS (([DefaultLibraryName] VARCHAR(MAX) NOT NULL));
    GO

    Here is the MSDN article that describes the package installation process - link.

    Thanks,
    Shau Phang
    Microsoft R Server Engineering

    • Marked as answer by JohnnyKahWang Monday, April 10, 2017 1:10 AM
    Monday, April 3, 2017 7:31 PM

All replies

  • can anyone please help? really appreciated ...
    Sunday, April 2, 2017 7:31 AM
  • ..............
    Sunday, April 2, 2017 11:40 PM
  • Hi Johnny,

    You might want to refer to this post which posted similar question as yours - link.

    You can run the following statement in SSMS to find out where is the default library and make sure ggplot2 zip file is there in the folder.

    EXECUTE sp_execute_external_script  @language = N'R'
    , @script = N'OutputDataSet <- data.frame(.libPaths());'
    WITH RESULT SETS (([DefaultLibraryName] VARCHAR(MAX) NOT NULL));
    GO

    Here is the MSDN article that describes the package installation process - link.

    Thanks,
    Shau Phang
    Microsoft R Server Engineering

    • Marked as answer by JohnnyKahWang Monday, April 10, 2017 1:10 AM
    Monday, April 3, 2017 7:31 PM
  • Hi Shau:

    Thanks a lot for your help, that actually works.

    Cheers

    Monday, April 10, 2017 1:10 AM