Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-6116 DataFrame API improvement umbrella ticket (Spark 1.5)
  3. SPARK-7982

crosstab should use 0 instead of null for pairs that don't appear

Log workAgile BoardRank to TopRank to BottomAttach filesAttach ScreenshotVotersStop watchingWatchersConvert to IssueLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

    Details

    • Type: Sub-task
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.4.0
    • Component/s: SQL
    • Labels:
    • Target Version/s:
    • Sprint:
      Spark 1.5 doc/QA sprint

      Description

      See the following

      In [79]: sqlContext.range(0, 10).stat.crosstab('id', 'id').show()
      +-----+----+----+----+----+----+----+----+----+----+----+
      |id_id|   0|   5|   1|   6|   9|   2|   7|   3|   8|   4|
      +-----+----+----+----+----+----+----+----+----+----+----+
      |    0|   1|null|null|null|null|null|null|null|null|null|
      |    5|null|null|null|null|null|   1|null|null|null|null|
      |    1|null|   1|null|null|null|null|null|null|null|null|
      |    6|null|null|null|null|null|null|   1|null|null|null|
      |    9|null|null|null|null|null|null|null|null|null|   1|
      |    2|null|null|   1|null|null|null|null|null|null|null|
      |    7|null|null|null|null|null|null|null|   1|null|null|
      |    3|null|null|null|   1|null|null|null|null|null|null|
      |    8|null|null|null|null|null|null|null|null|   1|null|
      |    4|null|null|null|null|   1|null|null|null|null|null|
      +-----+----+----+----+----+----+----+----+----+----+----+
      

      I think we should use 0 instead of null for these columns.

        Attachments

          Activity

          $i18n.getText('security.level.explanation', $currentSelection) Viewable by All Users
          Cancel

            People

              Dates

              • Created:
                Updated:
                Resolved:

                Agile

                  Issue deployment