That's for the situation where you're trying to autodetect the three column format, but the first row key in the file happens to begin with the '#' character. There needs to be a way to force the program to not interpret the first line as the format specifier.
- Doug On Wed, Feb 3, 2010 at 7:47 AM, Sanjit Jhala <[email protected]> wrote: > I'm not sure I understand the difference between 2 & 3. In 2 suppose the > first line does not start with #, in that case, based on the number of tabs > it switches between the two single cell per line formats. Since this case is > already covered by 2 what does FORCE_AUTODETECT add? > > -Sanjit > > > > On Tue, Feb 2, 2010 at 5:06 PM, Doug Judd <[email protected]> wrote: > >> I'd like to add the ability for the LOAD DATA INFILE command to >> auto-detect the format of the input file. Here's a proposal for how it >> would work: >> >> 1. If the HEADER_FILE option is supplied, obtain the format from that file >> >> 2. If no option is supplied, then if the first line begins with a '#' >> character, then determine the format from that line. Otherwise, if the >> first line contains two tabs, assume the format is (row, column, value). If >> the first line contains three tabs, assume the format is (timestamp, row, >> column, value). >> >> 3. If the FORCE_AUTODETECT option is supplied, then read the first line in >> the file and assume the file is in single-cell-per-line format. If the >> first line contains two tabs, assume the format is (row, column, value). If >> the first line contains three tabs, assume the format is (timestamp, row, >> column, value). >> >> I believe this should cover all situations. Let me know if you see any >> problems with this approach or have an alternate suggestion. >> >> - Doug >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Hypertable Development" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]<hypertable-dev%[email protected]> >> . >> For more options, visit this group at >> http://groups.google.com/group/hypertable-dev?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups > "Hypertable Development" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]<hypertable-dev%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/hypertable-dev?hl=en. > -- You received this message because you are subscribed to the Google Groups "Hypertable Development" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hypertable-dev?hl=en.
