Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-795

using cpimport on datetime of '2016-09-01 9:39' gives error

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Duplicate
    • 1.0.8, 1.0.9
    • Icebox
    • cpimport
    • None
    • CentOS

    Description

      Importing data using cpimport using the following sample data produces errors on datetime field. ColumnStore documentation states '9:5:0' is equilvalent
      Sample data:
      1288069,254,2016-07-24 00:05,Grant Avenue at Columbus Avenue,73,2016-07-24 00:09,Davis at Jackson,42,497,Subscriber,94111
      1288070,575,2016-07-24 00:07,Commercial at Montgomery,45,2016-07-24 00:17,Embarcadero at Bryant,54,288,Subscriber,94105
      1288071,435,2016-07-24 00:08,Paseo de San Antonio,7,2016-07-24 00:15,Japantown,9,223,Subscriber,95112
      1288072,7766,2016-07-24 1:30,Arena Green - SAP Center,14,2016-07-24 3:39,Arena Green - SAP Center,14,82,Customer,95123
      1288073,7754,2016-07-24 1:30,Arena Green - SAP Center,14,2016-07-24 3:40,Arena Green - SAP Center,14,167,Customer,95123
      1288074,222,2016-07-24 1:33,Steuart at Market,74,2016-07-24 1:37,Embarcadero at Bryant,54,197,Subscriber,94107
      1288075,411,2016-07-24 3:01,Market at Sansome,77,2016-07-24 3:07,2nd at Townsend,61,317,Subscriber,94105
      1288076,316,2016-07-24 3:19,Clay at Battery,41,2016-07-24 3:24,Grant Avenue at Columbus Avenue,73,519,Subscriber,94133
      1288077,31756,2016-07-24 3:20,Howard at 2nd,63,2016-07-24 12:09,San Francisco Caltrain (Townsend at 4th),70,632,Customer,94569
      1288078,4439,2016-07-24 4:20,Civic Center BART (7th at Market),72,2016-07-24 05:34,Embarcadero at Vallejo,48,560,Customer,95706
      1288079,349,2016-07-24 5:57,5th at Howard,57,2016-07-24 6:03,Howard at 2nd,63,471,Subscriber,94107
      1288080,20140,2016-07-24 6:34,Mountain View City Hall,27,2016-07-24 12:10,Mountain View Caltrain Station,28,128,Customer,94043
      1288081,378,2016-07-24 7:47,Grant Avenue at Columbus Avenue,73,2016-07-24 7:53,Steuart at Market,74,463,Subscriber,94133
      1288082,1369,2016-07-24 8:07,Davis at Jackson,42,2016-07-24 8:30,Davis at Jackson,42,364,Subscriber,94111
      1288083,401,2016-07-24 8:13,2nd at South Park,64,2016-07-24 8:19,Townsend at 7th,65,14,Subscriber,94105
      1288084,423,2016-07-24 8:14,Steuart at Market,74,2016-07-24 8:21,2nd at Townsend,61,652,Subscriber,94109
      1288085,209,2016-07-24 :33,Embarcadero at Bryant,54,2016-07-24 8:37,Embarcadero at Folsom,51,585,Subscriber,94105
      1288094,730,2016-07-24 08:52,Embarcadero at Bryant,54,2016-07-24 9:04,Embarcadero at Sansome,60,275,Subscriber,94105
      1288103,21814,2016-07-24 9:08,Market at 4th,76,2016-07-24 15:12,Market at 4th,76,15,Customer,80130
      1288107,129,2016-07-24 9:11,Broadway St at Battery St,82,2016-07-24 9:13,Davis at Jackson,42,482,Subscriber,94111
      1288110,473,2016-07-24 9:17,Davis at Jackson,42,2016-07-24 9:25,2nd at Folsom,62,482,Subscriber,94111
      1288111,2855,2016-07-24 9:21,Powell Street BART,39,2016-07-24 10:08,Yerba Buena Center of the Arts (3rd @ Howard),68,426,Customer,94569
      1288112,1793,2016-07-24 9:28,San Francisco Caltrain (Townsend at 4th),70,2016-07-24 9:58,San Francisco Caltrain (Townsend at 4th),70,475,Customer,89423
      1288113,1779,2016-07-24 9:29,San Francisco Caltrain (Townsend at 4th),70,2016-07-24 9:58,San Francisco Caltrain 2 (330 Townsend),69,675,Customer,89423
      1288114,650,2016-07-24 9:33,Davis at Jackson,42,2016-07-24 9:43,2nd at Townsend,61,364,Subscriber,94102
      1288115,650,2016-07-24 9:36,Market at 10th,67,2016-07-24 9:47,San Francisco Caltrain 2 (330 Townsend),69,389,Subscriber,94028
      1288118,691,2016-07-24 9:39,San Francisco Caltrain 2 (330 Townsend),69,2016-07-24 9:51,Harry Bridges Plaza (Ferry Building),50,662,Subscriber,95035
      1288119,349,2016-07-24 9:41,San Francisco Caltrain 2 (330 Townsend),69,2016-07-24 9:47,5th at Howard,57,277,Subscriber,94107
      1288120,334,2016-07-24 9:42,2nd at Townsend,61,2016-07-24 9:48,Yerba Buena Center of the Arts (3rd @ Howard),68,317,Subscriber,94107
      1288121,363,2016-07-24 9:45,2nd at Townsend,61,2016-07-24 9:51,Market at Sansome,77,429,Subscriber,94107
      1288122,197,2016-07-24 9:59,Temporary Transbay Terminal (Howard at Beale),55,2016-07-24 10:02,Howard at 2nd,63,349,Subscriber,94105

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              jmclaurin james mclaurin (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.